MsSql Simple Query method of all the data in the datasheet _mssql

The example in this article describes the method for MSSQL to simply query all the data in the data table. Share to everyone for your reference, specific as follows:

The following examples are given directly here:

SELECT * from Sys_logcontent SLC
WHERE SLC. loginfo_id in
(
 SELECT slc2. loginfo_id from Sys_logcontent slc2 GROUP by SLC2. loginfo_id having COUNT (*) >1
)

Simple description:

The key code is in the parentheses above. To query for all duplicate data, you can follow a field to count all the records in the field that have a total of more than 1 duplicate data, which can be counted by using group by, and then the statistics are queried again as a query condition.

I hope this article will help you with your SQL Server database program.