how to get top two salaries from employee tables

Answer Posted / satya

Hi,

Select * from emp e where 2>=(select count(*) from emp e
where sal>e.sal) order by desc sal.

Let me know if this query is wrong.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Actually by using severity you should know which one you need to solve so what is the need of priority?

702


How the application is launched to the production environment?

1188


Information about Automated Software Installer

1451


Please explain me v-model clearly i want to know how it works and want to know how it use in real time on a project please tell me its urgent and important for me understand .Please tell me my mail id is Chiku_69@yahoo.in Thank u

2141


What is pesticide paradox?

639






What is white box testing, and what are the various techniques?

676


what is the challenging position faced in the testing not in point of management point of view it must be in the point of while testing the application?

4016


What is the limit for test steps?It should be 10/20/30etc

1486


Please can any one tell me 1).Types of reports 2).Types of Meetings.

1302


What is Traditional testing & Object Oriented testing?

1954


What is severity and priority of bug? Give some example.

657


How would u test and automate an Antivirus application ?

1527


What is the difference between load and stress testing?

713


Changes and enhancements to system?

1587


what risks do u faced u r projest how do you solve

1628