select e1.* from emp e1 where 1=(select count(distinct e2.sal) from emp e

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

Question Posted / satish

Answer Posted / satish

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

if i want to use different values in datatable with each iteration of for loop what would i do ??/

1639

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

566

Explain what is the hybrid framework?

561

Explain me what is the difference between setspeed() and sleep() methods?

582

hi, I want to study TIA portla V11. where can I get online courses?

1379

Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com

1521

Tell me the fundamental difference between xpath and css selector?

556

Tell us what you know about table-driven testing?

539

Tell us what is junit? And what is junit annotation?

514

How can the user get a text of a web element?

521

how can i count the no of edit field in a page and fill the multiple edit field

2051

Tell me what is an absolute xpath?

525

What is modular automation?

559

Can you explain me what is object repository?

547

Explain me what are the main advantages of automation testing?

489