If you are trying to filter out duplicate records from your table.
SELECT DISTINCT column_name,id FROM table_name
GROUP BY coulumn_name
HAVING COUNT(column_name) > 1
The above sql would filter out duplicate records with their ids.
cheers.
The above sql would filter out duplicate records with their ids.
cheers.
Subscribe to:
Post Comments (Atom)
0 comments
Post a Comment