Write a query to find second highest salary of an employee.
Answer Posted / deepak falke
3rd highest sal from account :
SELECT TOP 1 Sal FROM account WHERE Sal IN
(SELECT distinct TOP 3 Sal FROM account ORDER BY Sal DESC)
order by sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Have you completed the cps exam? Which one?
Tell us how can you find if an element is displayed on the screen?
How can you create html test report from your test script?
Do you know how to verify if the checkbox/radio is checked or not?
How do you plan test automation?
What are the different types of testing framework techniques?
What is an automated test script?
How do you choose which automation tool is best for your specific scenario?
What is test driven development?
What should you do after finding a bug?
Do you know how to check if a button is enabled on the page?
Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..
Explain me what kinds of annotations are used in testng?
wat would be the parameteries for ul testing for web applilcation
What is the difference between close and quit command?