Answer / brajesh kumar

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

Answer / venki

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

Answer / madhu

to get nth higest value

SELECT EMP_NAME,EMP_SALARY
FROM EMP_TABLE
ORDER BY EMP_SALARY DESC
LIMIT n-1, 1

this is for mysql server

Answer / ramaniranjan das

select top1 * from (select distinct top nth from table name
by column name ) alisa name of table order by column name

Example:-Create table tab_employee
(
Emp_id int,
Emp_name varchar(50),
Emp_salary money,
Emp_deg varchar(30),
emp_add varchar(100)
);
INSERT INTO tab_employee
VALUES ('1001','ANIL','18000','MANAGER','hyd')
Go
INSERT INTO tab_employee
VALUES ('1002','AKIL','6000','CLERK','Mub')
Go
INSERT INTO tab_employee
VALUES ('1003','VINOD','7000','SALESMAN','Bang' )
GO
INSERT INTO tab_employee
VALUES ('1004','VIKAS','8000','SALESMAN','BBSR' )
GO
INSERT INTO tab_employee
VALUES ('1005','SUNIL','15000','MANAGER','Orissa' )

select top 1 * from tab_employee where Emp_salary not in
(Select Distinct top 3 Emp_salary from tab_employee order
by Emp_salary Desc)order by Emp_salary Desc

Answer / bharath

select e1.* from emp e1
where &n=
(select count(distinct(*))
from emp e2
where e2.sal>e1.sal);

Answer / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

Answer / jaya u

SELECT A.EMPNAME ,A.SAL FROM EMP A
WHERE A.SAL = (SELECT DISTINCT (b.sal)
FROM EMP B WHERE ROWNUM = &N
ORDER BY B.SAL DESC );

Answer / sunil panghal

select max(salary) from employees

Answer / sunil panghal

select salary from emp where salary=(select max(salary)
from emp)

Answer / brajesh kumar

SELECT *FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP)

What are advantages of dateset in datastage?

0 Answers   iGate,

What do database buffers contain?

0 Answers  

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers   Oracle,

How are Indexes Update ?

1 Answers  

How to generate query output in html format?

0 Answers  

What is an oracle database?

0 Answers  

What are the Limitations of a CHECK Constraint ?

5 Answers  

How to execute the package in oracle?

0 Answers  

how to find the second highest salary in a given table????

5 Answers  

Explain about functional dependency and its relation with table design?

0 Answers  

How to concatenate two text values in oracle?

0 Answers