select * from emp A where 2=(select count(*) from emp B where A.sal <

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

Question Posted / murlidhar

Answer Posted / murlidhar

select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)

Is This Answer Correct ?

41 Yes

36 No

Please Help Members By Posting Answers For Below Questions

Is automation testing in agile methodology useful or not?

526

Tell me what is tsl? What 4gl is it similar too?

581

Where to maintain information like login, password and url?

535

What are the differences between open source tools, vendor tools, and in-house tools?

547

all clients are using at once if any problem raise?

1882

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

529

What are pros and cons of automating tests at ui layer?

555

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

511

Can you list some other automation testing tools that you are familiar with?

578

How can you create html test report from your test script?

494

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

1116

Bug report formate in bugzilla

1629

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

7676

What is difference between selenium and QTP tools Which is best tool... Which is most used tool

939

Can you achieve 100% automation?

587