Sql Server 2005 Query
Homepage
About Us
Topics
Contact Us
Advertise
Jobs
Walkin
Most Visited Questions
How to get number of row in each table in database
How to get number of time a character occur in a string
How to check a primary key exists or not in table
Different Date and Time Format
How to get first day of week
How to select all duplicate records from a table
Home
>>
Dababase Interview Questions
>>
Sql Server 2005 Query
How to select all duplicate records from a table
Posted on May 7th , 2010 by Admin
select Col, count(Col) from TableName group by field having count(*) > 1
Site Search
