SELECT MIN(Sal) FROM Employee WHERE Sal IN (SELECT TOP 4 Sal FROM employe

Write a query to find second highest salary of an employee.

Question Posted / rajesh kole

Answer Posted / rajesh kole

SELECT MIN(Sal) FROM Employee
WHERE Sal IN
(SELECT TOP 4 Sal FROM employee ORDER BY Sal DESC)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Once you identify the tool what would be your next steps?

590

IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

1879

Give some examples for defect management tools?

575

Can the activities of test case design be automated?

1441

Elaborate the fields in bug report in automated testing

552

Please explain what is the difference between findelement () and findelements ()?

582

what is critical test case ? please give an example .

1402

What is keyword driven automation?

592

What is the purpose of deselectall() method?

513

Can you list some other automation testing tools that you are familiar with?

579

Tell me what is tsl? What 4gl is it similar too?

582

Give some examples for functional & regression test tools?

509

What are the frameworks available in rc?

586

I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....

1929

On what basis you can map the success of automation testing?

533