Filtering for UNIQUE records in one table 2

[shilpashetty27]

Hi all,

I've been trying to accomplish the filtering out of duplicate data in the following table.

ID Name Code
1 x Pink
2 y Red
3 z Orange
4 z Orange

From the table above, I'm trying to filter out duplicate 'Name' fields and obtain only unique 'Name' fields with corresponding 'Code' fields.

Therefore, i'd like the results of my query to look like this:

ID Name Code
1 x Pink
2 y Red
3 z Orange


Any help on this is appreciated.
Tks in advance,
Cheers,
Shilpa

 

[PHV]

SELECT Min(ID) AS MinID, Name, Code
FROM yourTable
GROUP BY Name, Code

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[shilpashetty27]

Thanks PHV for your reply. I did try out your suggestion but unfortunately it doesn't seem to be filtering out the duplicates in the 'Name' column.

Any more ideas perhaps???


Thanks again!
Shilpa

 

[PHV]

What are your actual SQL code, actual result and expected result ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Karja]

What about a DISTINCT?

SELECT DISTINCT Name, Id, Code
FROM yourTable

 

[shilpashetty27]

Thanks PHV and Karja,

I checked PHV's method again and it just so happened that I had overlooked something.
Both your suggestions worked perfectly fine for me!

cheers,
Shilpa