DISTINCT QUERY

[MrBaRRon]

Hi everybody,

I would like to select all "id" in a table ONLY where "raff" is distinct.

I think it should be such a thing:

SELECT id FROM mytable WHERE (SELECT DISTINCT raff) or

SELECT id FROM (SELECT DISTINCT raff FROM mytable)

So what is the correct syntax

Thnak U

BaRRon

 

[nigelrivett]

What is the structure of the table?

select id = max(id) , raff
from tbl
group by raff
having count(*) = 1



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Lekar]

Also, depending on the structure of ur table:
[tt]
Select Max(ID)
From MyTable
Group By Raff
[tt]

;-) Lenin