Re: Finding highest or lowest values in a column?

From: Jason Burgoyne <jason.burgoyne_at_bms.com>
Date: Tue, 23 Jan 2001 07:46:48 -0500
Message-ID: <3A6D7D38.1183688D_at_bms.com>


select * from TableA where ID_NUMBER IN ( Select max(ID_NUMBER) from TableA);

Hope this helps.

JB

dexter wrote:

> Hello,
> Can someone help me with the SQL statement to find the highest or lowest
> value in a column.
> example:
> select * from TableA where ID_NUMBER = 'highest';
> Thanks in Advance,
> Dex
Received on Tue Jan 23 2001 - 13:46:48 CET

Original text of this message