Masif, why would you call that as a double entry? The data seems to be a raw data that isn't normalized. If you want to just select data for one column, without having any duplicates, you could use the query
Code:SELECT [Column_Name] FROM [Table_Name] GROUP BY [Column_Name]




Reply With Quote
Bookmarks