Answer / la

select max(sal) from emp;

Answer / surya

select * from emp where &n-1=(select count(distinct sal)
from emp e where emp.sal<e.sal);

For example:-
If you enter n=1,it will display first highest salary
if you enter n=2,it will display second highest salary
......

if you enter n=nth,it will display nth salary

Answer / chandiran

select max(sal) from Employee

Answer / samir kumar sahoo

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

Answer / ela tiku

select max(sal) from emp

<<<assuming emp is the table name and sal is the column
name>>>

Answer / tulasi

select * from emp x where 1=(select count(distinct sal)
from emp y where x.sal<=y.sal);

query to find nth sal

select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal);

Answer / mak

it's right

Answer / o p yadav

select max (salary) from emp
emp is a table name and salary is a coloum name

Answer / vali

according to samir kumar sahoo we cant find ans i think
bcoz
if u enter rownum='x' u can not find the data
select * from emp where rownum=10
ans; no rows found

Answer / suren

hi Im SureRishi

SELECT *
FROM Employee E1
WHERE (4-1) = (
SELECT COUNT(DISTINCT(E2.Salary))
FROM Employee E2
WHERE E2.Salary > E1.Salary)

What does `(+)` do in a where clause?

1 Answers  

What is SYSTEM tablespace and When is it Created?

2 Answers  

What is the quickest way to fetch the data from a table?

0 Answers  

How to drop a stored procedure in oracle?

0 Answers  

How to create a server parameter file?

0 Answers  

What is a synonym? What are its various types?

0 Answers  

Can we create more than one constraint to column ?

6 Answers  

What is Trace File ?

4 Answers   Thermotech,

Display Odd/ Even number of records?

3 Answers  

How to install oracle odbc drivers?

0 Answers  

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

What WHERE CURRENT OF clause does in a cursor?

2 Answers