Archive for December 20th, 2007

To find out duplicate rows in the table

Thursday, December 20th, 2007

SELECT sheet_id, COUNT( sheet_id ) AS NumOccurrences
FROM candidate_sheet
GROUP BY sheet_id
HAVING
(COUNT( sheet_id )>1)

The above query will returns the sheet_id and number of occurrences of sheet_id who’s sheet_id will exist more than one time in the table.

Posted by Kalaivani S

Posted in PHP Programming | No Comments »