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 to define an anonymous procedure with variables?

0 Answers  

What are the various oracle database objects?

0 Answers  

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

What is BBED in Oracle?

0 Answers   MCN Solutions,

How to recover a dropped table in oracle?

0 Answers  

What is partitioned table in Oracle?

0 Answers   MCN Solutions,

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

What are a query and state the different types of queries and their uses?

0 Answers  

What is a static data dictionary in oracle?

0 Answers  

What is a Sequence ?

3 Answers  

What is an oracle recycle bin?

0 Answers