quote:Originally posted by Madhivanan
Also post some sample data and the result you want. Why do you not want to use Distinct?
I have only one column returning duplicated IDs. So if we use GROUP BY, is efficient to DISTINCT.
We have a query which returns duplicates in ID column - want to know how to write a query which avoids duplicate in the query results (WITHOUT using...
Separate names with a comma.