Posted by Aaron Lawrence on 02/14/06 09:15

Hello all.

Is there a simpler way to write something like this:

select column_a from table
where column_b = ( select max( column_b ) from table )

ie. find the row where column_b is at it's maximum and return another
column's value?

something like (hypothetically)

select column_a from table
where column_b is max

Leaving aside the issue of whether max( column_b ) is unique ...

Thanks.

Aaron

• Next in forum: Re: select another column where max
• Prev in forum: Re: fetching unique pins...
• Thread view: select another column where max

[Reply to this message]