Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128732 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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 is the difference between keyword driven frame work and data driven frame work.
What is functional and regression testing?
Give some examples for performance test tools?
What are the types of the framework used in software automation testing?
On what basis you can map the success of automation testing?
What is a xpath?
What are the different types of testing framework techniques?
Why do you prefer selenium automation tool?
Once you identify the tool what would be your next steps?
Tell me what databases can test director reside on?
How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.
What are the advantages of manual testing and automated testing?
Explain me how do you send enter/tab keys in webdriver?
Tell us how can you find if an element is displayed on the screen?
Can you achieve 100% automation?
