select e1.* from emp where 1=(select e2.sal from emp e2 where e2.sal>e

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

Question Posted / satish

Answer Posted / satish

select e1.* from emp where 1=(select e2.sal from emp e2
where e2.sal>e1.sal)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to select an automation tool best matched for your project?

1005

What is tree view in automation testing?

978

Is ui level testing possible?

993

notice the distinction between data driven testing and retesting?

976

What are the limitations of automating software testing?

2104

What are the most popular tools for automation testing?

1002

What are the frameworks available in rc?

1171

What are the important modules of an automation testing framework?

1073

Tell me what is automation testing?

1017

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

983

Tell me what is regression testing?

1031

Tell us can we find all links on a web page?

992

What are the risks associated in automation testing?

1147

How to Rcognize the Objects in the Web Page Dialog Using QTP

2507

What is keyword driven automation?

1059