Friday, December 28, 2007

How to get Duplicate rows from table

Example:

SELECT number, count(*) FROM doc_master GROUP BY number HAVING count(*) > 1

No comments: