select max(sal)from emp e1 where 2<=(select count(*) from emp e2 where

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

Question Posted / vittal

Answer Posted / vittal

select max(sal)from emp e1 where 2<=(select count(*) from
emp e2 where e1.sal <= e2.sal);

Is This Answer Correct ?

66 Yes

38 No

Please Help Members By Posting Answers For Below Questions

is anybody suggest me which one is the best testing institute in ameerpet hydrabad

2167

what is GDC

2170

Explain what sikuli is?

1066

What is tree view in automation testing?

983

Explain me what is a framework and what are the frameworks available in rc?

974

Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com

1569

Which test cases can be automated?

1003

Explain what is a relative xpath?

1084

What is ‘good code’? What is ‘good design’?

988

What is the purpose of deselectall() method?

1033

WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

2335

Can the activities of test case design be automated?

1875

What issues come up in test automation, and how do you manage them?

2479

Tell me what kind of tests should not be automated?

979

Is automation testing a complete replacement for manual software testing?

1125