Re: SQL problem. HELP!

Jerry,
The traditional way to find the highest NN rows in a table is:

select col1,col2 from tab1 t where NN >= (select count(*) from tab1 tt where t.col2 < tt.col2);

Regards,
AJ.

Jerry Glass wrote:
>
> I am lookin for a way to solve a problem. I need to find the highest
> values in a list and only return those values (i.e., find the three
> highest values and only return those three rows)
  Received on Tue Jun 17 1997 - 00:00:00 CDT