Home » Other » Test » Finding two highest salaries from EMP,DEPT tables
Finding two highest salaries from EMP,DEPT tables [message #623403] Wed, 10 September 2014 01:03 Go to next message
sujana123
Messages: 2
Registered: September 2014
Location: bangalore
Junior Member
Hi,

Can anyone please help in writing the query.

Scenario:

Finding two highest salaries in each department. Query should display employee name and department name also.

Thanks in advance.
Re: Finding two highest salaries from EMP,DEPT tables [message #623404 is a reply to message #623403] Wed, 10 September 2014 01:15 Go to previous message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The purpose of tis forum is to test your posts not to actually get an answer.
If this is a real question then post it in SQL & PL/SQL forum.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Note that we don't give solution to homework but we can help you to achieve it if you show what you already tried and where you are stuck.
Also have a look at SQL FAQ.

[Updated on: Wed, 10 September 2014 01:19]

Report message to a moderator

Previous Topic: test1
Next Topic: Test edit without substantial edit
Goto Forum:
  


Current Time: Sat Dec 16 16:58:53 CST 2017

Total time taken to generate the page: 0.01031 seconds