select sal from (select rank() OVER (order by sal desc) sno ,sal from emp

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

Question Posted / rajkumar mandala

72 Answers
128799 Views
ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
E-Mail Answers

Answer Posted / rajkumar mandala

select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n

here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...

Is This Answer Correct ?

7 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Tell me what are pros and cons of automating tests at ui layer?

1049

What are the most popular tools for automation testing?

1012

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

1018

Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.

2088

explain add in manager and virtual object wizard in winrunner

2177

Is automation testing a complete replacement for manual software testing?

1129

Explain me what kinds of annotations are used in testng?

915

Where you have applied oops in automation framework?

1133

Tell us what methods of robot class do you know?

978

Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932

2061

What is junit? And what is junit annotation?

1106

When is automation testing useful?

998

Why automation testing?

1075

Can you explain data-driven testing?

1115

Tell me what databases can test director reside on?

940