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

Which protocol cam be used to makw jdbc connection woth loadrunner

955

Tell us what methods of robot class do you know?

926

what r the diffence between QTP 8.2 & QTP9.0?

2054

Name a couple of standard web function found in the function generator?

971

What are the steps involved in the automation process ?

1220

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

999

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

1351

How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

2385

Any one suggest me for Free ware (Opensource) Automation tool for regression testing.

1946

Tell us what automation tools could be used for post-release validation with continuous integration?

964

Define sdlc in testing.

981

What is tree view in automation testing?

924

Tell me what type of scenarios can be automated?

861

What are the advantages of test automation?

1009

how to write ciertification in QTP?

2054