select * from emp A where 1=(select count(*) from emp B where A.SALARY &l

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

Question Posted / aj

Answer Posted / aj

select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)

Is This Answer Correct ?

12 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

946

did anybody take online training from Mind Q systems hyderabad? please share your experience. thanks

2227

Give some examples for functional & regression test tools?

1013

What is open source tool and give example?

1066

What is the different between GUI map and GUI map files?

2207

What is junit annotation?

1093

How the object properties will be recognised by the tool If the functions/ statements are written manually?

2272

List some advantages and disadvantages of automation testing.

989

Types of F/w in Automation

1321

How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.

1737

What is test driven development?

1156

How do we Test the C++ and Unix Application Using Automated Tool.

2570

suggest me the free online books on software testing?

1959

Can we do automation testing without a framework? If yes, then why do we need a framework?

1258

What are the advantages of test automation?

1121