Re: selecting max row out of many

select * from x main where main.c in (select max(c) from x where x.b=main.b) and main.b=1

Bhavin Shah ïèøåò â ñîîáùåíèè ...
:Hi,
:
:How do you select one row with the highest column C
:out of many possible rows in sql?
:
:Ex: Table X
:
:A B C
:--------------------
:abc 1 8
:def 1 9
:ghi 2 1
:
:SELECT * FROM X WHERE B='1' will get me the first two rows, but
:how do I filter it out using column C, like taking the row
:with the highest C? I tried using max, but I couldn't get it
:to work.
:
:Thanks in advance.
Received on Wed Aug 09 2000 - 00:00:00 CDT