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

This article will explain in detail how to remove duplicate records and obtain duplicate records in SQL sentences. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

SQL statement to remove duplicate records and get duplicate records-query a table to effectively remove duplicate records, and UserID is the self-growing primary key RoleID queries all table names in the sqlserveraccess database for the repeating field SELECTMIN (UserID) ASUserID,RoleIDFROMtmpTableGROUPBYRoleID SELECTRoleIDFROMtmpTableGROUPBYRoleIDHAVING (COUNT (*) > 1) SELECTDISTINCT*FROMtmpTable sql statement. Field names 04:21SQLSERVER check all table names: selectnamefromsysobjectswheretype='U' query table all field names: SelectnamefromsyscolumnsWhereID=OBJECT_ID ('table name') select*frominformation_schema.tables select*frominformation_schema.views select*frominformation_schema.columns ACCESS View all table names: selectnamefromMSysObjectswheretype=1andflags=0 MSysObjects is a system object The default is hidden. It can be displayed through tools, options, views, displays, and system objects.

On the SQL statement on how to remove duplicate records and get duplicate records to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.