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.

Report message to a moderator

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: 68351
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 06 19:51:21 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.