Home » Other » Training & Certification » Somebody help me solve this
Somebody help me solve this [message #284817] Sat, 01 December 2007 08:33 Go to next message
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
Re: Somebody help me solve this [message #284819 is a reply to message #284817] Sat, 01 December 2007 09:36 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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.

./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:
  


Current Time: Sun Dec 11 08:23:52 CST 2016

Total time taken to generate the page: 0.08614 seconds