Answer / ashish

select salary from
(select dense_rank() over(order by salary desc) as highest, salary from employee)as y
where highest=2

: replace 2 with n.... it will give nth highest salary
: rank() will work correctly only if all the salaries in employee table are distinct.
: dense_rank() will work correctly, does'nt matter salaries are distinct or NOT.

Answer / shahnawaz

please check this one .
first rank the salary coloum and then find nth heigest
salary
use rank function


select * from
(select a.*, rank()over(order by salary desc) rn from
emp_shah a)

Answer / prashant srivastava

**Exact answer to the question**

SELECT MIN(e1.Salary) FROM emp e1 WHERE e1.Salary IN
(Select e2.Salary from emp e2 ORDER BY e2.Salary DESC FETCH
FIRST 2 ROWS ONLY)

**Generic Solution**

SELECT MIN(e1.Salary) FROM emp e1 WHERE e1.Salary IN
(Select e2.Salary from emp e2 ORDER BY e2.Salary DESC FETCH
FIRST n ROWS ONLY)

Just replace n as the asked rank of the salary. For instance

If 29th highest salary is asked then replace n with 29..
simple...isn't it? :):)

Answer / raaghav

Try this query
===================
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 '(n is always greater than one)

E.g.:-
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / abhishek

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT
MAX(SALARY) FROM EMPLOYEE)

Answer / ayyappa

Select max(esal) from emp where esal < (Select max
(esal) from emp)

Answer / jia

select * from employee orderby salary DESC
Limit 1,1

Answer / rk

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...

Answer / jawad humayun

SELECT MIN(salary)
FROM employ
WHERE salary IN (SELECT salary
FROM employ
ORDER BY salary DESC
LIMIT 2)

This querry will give the 2nd highest salary
to have nth highest salary replace 'LIMIT 2' by 'LIMIT n'

Answer / barochia dharmesh

select Income from (
select Rank() over(order by Income desc) topRecord, Income
from (select distinct Income from tblName) tbl ) tbl2
where topRecord = 2

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

0 Answers  

Explain what is the difference between findelement () and findelements ()?

0 Answers  

hi........ i want kniow about automation testing.how to work as automation tester.If we have a software so how to test the software from automation tool like QTP please give me answer in detail or any link thanks

1 Answers  

what are the steps followed in unit testing, system testing, integration testing

0 Answers  

How do you Test Credit Card Validation

2 Answers   V2 Solutions,

What is tree view in automation testing?

0 Answers  

How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.

0 Answers  

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

0 Answers  

has anyone attended mr. g c reddy sir classes? whom you guys want me to choose Mr. G C Reddy or Mr. Suresh Reddy ? Please help!!!!!!!!!!!

0 Answers  

Explain how to perform load-testing?

0 Answers  

Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..

0 Answers  

What is keyword driven automation?

0 Answers