Shulou(Shulou.com)05/31 Report--

How to query all the duplicate data of the data table in MSSql? aiming at this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

The following examples are given directly here:

SELECT * FROM SYS_LogContent slcWHERE slc.LogInfo_ID IN (SELECT slc2.LogInfo_ID FROM SYS_LogContent slc2 GROUP BY slc2.LogInfo_ID HAVING COUNT (*) > 1)

A brief description:

The key code is in parentheses above. To query all the duplicated data, you can count all the records in the field with a total number of duplicated data greater than 1 according to a certain field. This process can be counted using GROUP BY, and then the statistical results can be queried again as query conditions.

This is the answer to all the duplicate data questions about how to query the data table in MSSql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.