tutorials, tips and tricks to design a Sql Server, Cloud Service . Micrsoft Interview Question
Friday, January 21, 2011
How to select all duplicate records from a table
select Col, count(Col) from TableName group by field having count(*) > 1
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment