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 happens to the current transaction if the session is ended?

0 Answers  

Hi Can any one tell me what are the API's used in requisition import.

0 Answers  

Explain the use of show option in imp command.

0 Answers  

Is oracle a programming language?

0 Answers  

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

0 Answers  

Explain integrity constraint?

0 Answers  

What are nested tables?

0 Answers  

How to view the tablespaces in the current database?

0 Answers  

How to connect ms access to oracle servers?

0 Answers  

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

Can we commit inside a function in oracle?

0 Answers  

What is a OUTER JOIN?

1 Answers