OraFAQ Forum: Training & Certification » Somebody help me solve this

Home » Other » Training & Certification » Somebody help me solve this

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Somebody help me solve this [message #284817]

Sat, 01 December 2007 08:33

sqlstar_student
Messages: 42
Registered: November 2007

Member

Display the third maximum salary from employees table

I can get the max of salaries by using max(salary) but third max how?

Another problem is

Display the 10 senior most employees of my company

Report message to a moderator

Re: Somebody help me solve this [message #284819 is a reply to message #284817]

Sat, 01 December 2007 09:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What have you tried so far?

Depending on your true requirements you should consider RANK or DENSE_RANK.

[Updated on: Sat, 01 December 2007 09:36]

Report message to a moderator

Re: Somebody help me solve this [message #284821 is a reply to message #284817]

Sat, 01 December 2007 10:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

FAQ.

Read and follow OraFAQ Forum Guide.

We don't make homework.
You ALWAYS have to search BEFORE posting.
You have to post a MEANINGFUL title.

/forum/fa/448/0/

Regards
Michel

[Updated on: Sat, 01 December 2007 10:15]

Report message to a moderator

Previous Topic:	sql query
Next Topic:	Help with this query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:42:47 CST 2024