Write a query to find second highest salary of an employee.
Answer Posted / khurram
The Simplest, easy, Understandable solution is
select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)
Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the differences between open source tools, vendor tools, and in-house tools?
Please explain what is the hybrid framework?
Name some of the commonly used automation testing tools that are used for functional automation.
Tell me what is intellij?
How many test cases have you automated per day?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
Is automation testing a black box testing or white-box testing?
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
Which package can be imported while working with webdriver?
Can we do automation testing without a framework? If yes, then why do we need a framework?
Why do you want to keep this kind of information in a separate file and not directly in the code?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting