Answer / mihir nasikkar

Here n is 3


SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / gayathri

if you compare the salary slip u can find

Answer / karunakar varma

select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3

Answer / abbas

SELECT * FROM
(
SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMPLOYEE)
WHERE RANKNEW = 3

Answer / mahesh

select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))

Answer / nirad

select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc


if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3

Answer / chinmaya

Select Top 1 Sal from (Select Top 3 Sal from emporder by
Sal desc) x order by Sal

Answer / vanaja

select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))

Answer / sam

Guys
See the correct answer.

select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)

Answer / ajit

SQL QUERIES FOR FINDING Nth HIGHEST SALARY

SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  

How can we find out the current date and time in oracle?

0 Answers  

How do I use unicode codesets with the weblogic jdriver for oracle driver?

0 Answers  

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,

What is bind variable in oracle 11g?

0 Answers  

What privilege is needed for a user to create tables in oracle?

0 Answers  

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

how to select second mauximum value in a given table under salary column

6 Answers   Sapient,

What is the string concatenation operator in oracle?

0 Answers