Re: Beginner's question
From: Guy Vilquin <vilquin_at_cenatls.cena.dgac.fr>
Date: Thu, 25 Feb 1993 08:36:32 GMT
Message-ID: <1993Feb25.083632.4550_at_cenatls.cena.dgac.fr>
Date: Thu, 25 Feb 1993 08:36:32 GMT
Message-ID: <1993Feb25.083632.4550_at_cenatls.cena.dgac.fr>
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
|>
Select * from table where column = (select max(column) from table) Received on Thu Feb 25 1993 - 09:36:32 CET