Re: Beginner's question

In article <ecSp03Brcazg00_at_amdahl.uts.amdahl.com>, rtan@.uts.amdahl.com (Rick Tan) writes:
|> Hi,
|>
|> I need to retrieve a row from a table. The row selected must have the
|> largest value in a field. What SQL statement will do the trick?
|> Thanks in advance for any help.
|>
|> Rick

Sounds like you want to say

select * from T
where C = (select max(C) from T);

Roderick Manalac
Oracle Corp. Received on Sat Feb 27 1993 - 06:11:31 CET