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

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

What is autonomous transaction?

6 Answers  

How to use regular expression in pattern match conditions in oracle?

0 Answers  

What is currency type in database ?

3 Answers   TCS,

What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers  

What is trigger associated with the timer ?

1 Answers   Oracle,

What are the execution control statements?

0 Answers  

What is an oracle data file?

0 Answers  

What is data file?

0 Answers  

How to select all columns of all rows from a table in oracle?

0 Answers  

How to drop a stored procedure in oracle?

0 Answers  

What is the usage of control file in oracle?

0 Answers