Write a query to find second highest salary of an employee.
Answer Posted / bhaskar reddy thamma
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
suggest me the free online books on software testing?
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
what is GDC
Tell me what databases can test director reside on?
Please explain how to perform load-testing?
notice the distinction between data driven testing and retesting?
Explain what is the difference between findelement () and findelements ()?
How software testing is handled?
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
hi, I want to study TIA portla V11. where can I get online courses?
What is Ticketing tool? Has it any other names? What is the purpose of this?
Give some examples for functional & regression test tools?
What is ‘good code’? What is ‘good design’?
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Do you know what is the purpose of deselectall() method?