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
Actually by using severity you should know which one you need to solve so what is the need of priority?
How the application is launched to the production environment?
Information about Automated Software Installer
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
What is pesticide paradox?
What is white box testing, and what are the various techniques?
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?
What is the limit for test steps?It should be 10/20/30etc
Please can any one tell me 1).Types of reports 2).Types of Meetings.
What is Traditional testing & Object Oriented testing?
What is severity and priority of bug? Give some example.
How would u test and automate an Antivirus application ?
What is the difference between load and stress testing?
Changes and enhancements to system?
what risks do u faced u r projest how do you solve