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

Name some of the commonly used automation testing tools that are used for non-functional automation.

961

Differentiate between hdam and hidam database?

931

WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT

2230

What all things can you automate?

1020

What are the primary features of good automation tool ?

995

what is critical test case ? please give an example .

1795

Tell me what databases can test director reside on?

882

What are the advantages of automation testing?

938

Tell me what is automation testing?

966

What are different coverages in function testing?

1093

List of Test Management Tools??Is Quality Center Test Management tools

1728

What type of scenarios can't be automated?

1041

What is open source tool and give example?

945

How could you explain the main difference between webdriver and rc?

1087

Can you tell some good coding practices while automation?

1009