Answer / sanil

select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;

Answer / anish nama

select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)

Answer / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

Answer / brijesh

hi,

this query gives you the Nth highest salary, the trick is to
write (N-1) in the given place;

select salary from table as table1

where (n-1) =

(select count(salary) from table

where table1.salary<salary);

Answer / mamta

select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4

Answer / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

Answer / alka

select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3

Answer / tejeswara rao potnuru

Find Out The Nth Highest Salary


SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Answer / husenaiah.b

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

Answer / naveen kumar

Hi everybody,
This is one way to get the third highest salary
select ROWNUM as RANK from (select * from emp order by sal)
where ROWNUM<=3

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

Why cursor variables are easier to use than cursors?

0 Answers  

Why required to run root.sh at the time of installation and what exactly it will do

1 Answers  

what is the syntax of UPDATE command?

8 Answers  

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers   Infosys,

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

Difference between the “verify” and “feedback” command?

0 Answers  

What is an oracle cursor variable?

0 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

What are the uses of linked server and explain it in detail?

0 Answers  

How to drop an existing view in oracle?

0 Answers  

How to create a testing table in oracle?

0 Answers