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

On what factors can you map the success of automation testing?

0 Answers  

What are the main attributes of test automation?

0 Answers  

how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns

0 Answers  

On what basis you can map the success of automation testing?

0 Answers  

what is aom and how to add object repository? i am very new to QTP please help me

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  

Generic function for selecting a Radio Button in a Dialog

0 Answers   Ness Technologies,

Hi friends please tell me regardinr to QTP descriptive programming. if any materials are there suggest me. or if you have please give me. thank u waiting for reply

1 Answers  

what is defferevce between QA and QC

3 Answers   Tarang,

What is mean by ARGO testing? Can you please explain anyone

0 Answers  

Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com

0 Answers  

how is the best faculty for Selenium in Hyderabad?

2 Answers