select *from emp e1 where &n =(select count(*) from emp where sal >

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

Question Posted / sweety spear

Answer Posted / sweety spear

select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the types of the framework used in software automation testing?

1063

What is a framework for automation testing?

1079

Tell me what is automation testing?

1017

What are the different types of testing framework techniques?

983

What is the difference between close and quit command?

1075

List some advantages and disadvantages of automation testing.

929

What is the Differnce between Client/Server Testing and Web Based Testing?

9360

Which package can be imported while working with webdriver?

1430

What are the steps involved in the automation process ?

1277

How could the web element attributes be inspected in order to use them in different locators?

1007

What is a critical bug in a testing field?

1142

Explain me which web driver implementation is the fastest?

989

What is data - driven automation?

2673

Tell us what you know about table-driven testing?

981

When do you prefer manual testing over automation testing?

975