SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2 SALARY FROM EMP ORD

how to get top two salaries from employee tables

Question Posted / sivaprasad

Answer Posted / sivaprasad

SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.

OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How we allocate the priority(Blocker, Critical, etc.,) in Testing?

1794

What is junit & api?

2230

What is Bomb Testing?

2215

how can u prepare the test plan?

2226

Write the test cases for yahoo home page

2227

What is mutation testing & when can it be done?

1106

Architectural structure of the insurance project?

1241

Can anyone please tell in detail about the Rally tool and how a tester is going to use it.

2515

What is Registry?

2035

What is stub?

1186

why testcases are written and what is the importance?

1553

What is Stability and Performance Testing in Testing the TV

2306

What do you like about computers?

2200

What is coverage and what are the different types of coverage techniques?

1095

What is the difference between a defect and a failure?

1102