Question Locked

Oracle 9i - Sql Query

0 helpful

5 replies

by demilune1984 Sep 8, 2008 last reply Sep 11, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to select maximum salary, without using maximum, minimum, in, any, all, rowid. How can we solve this?

5 replies

Clarifications

Select Top 1 Salary From Salaries Order By Salary Desc

would be one way.

Hi,

Actually the query you recommended is not working in oracle 9i platform.
Can you please help further?
Waiting for your reply.

Google is your friend.

There's one that uses rownum(), but look for the second version...

There is also a rank function, which I know f'all about...

HtHs

Thanks alot.

This discussion is closed to new replies.