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
Give some examples for functional & regression test tools?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
Explain me what the webdriver supported mobile testing drivers do you know?
What are the points that are covered while planning phase of automation ?
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
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
Can you achieve 100% automation?
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.
Explain what is the difference between findelement () and findelements ()?
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.?
Do you know what is a data-driven framework?
what are the steps followed in unit testing, system testing, integration testing
How software testing is handled?
Can the activities of test case design be automated?
Explain load testing on websites?