ASP.NET - how to remove duplicate values in a column in sql
Asked By sri on 28-Sep-12 09:38 AM
how to remove duplicate values in a column in sql..?
Hemanth Kumar replied to sri on 29-Sep-12 01:46 AM
We can do this Removig Duplicate values from a Column in Many ways.I am giving one example based on my experience.If you want more Google the Question title.
Jitendra Faye replied to sri on 01-Oct-12 01:24 AM
Try to get record using distinct
select distinct colname from tanlename
Cosmos Mysore replied to sri on 01-Oct-12 04:59 AM
SELECT identity column(fid)
GROUP BY fid
HAVING COUNT(*) > 1
SET ROWCOUNT 1
DELETE FROM table
WHERE fid = 1 AND fid = 1