Question

Locked

Oracle 9i - Sql Query

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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Nsure of the exact syntax but

by Tony Hopkinson In reply to Oracle 9i - Sql Query

Select Top 1 Salary From Salaries Order By Salary Desc

would be one way.

Collapse -

Thanks

by demilune1984 In reply to Nsure of the exact syntax ...

Hi,

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

Collapse -

Here you go

by Tony Hopkinson In reply to Oracle 9i - Sql Query

Google is your friend.

http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx

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

Collapse -

Thanks

by demilune1984 In reply to Here you go

Thanks alot.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums