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 are the diffeenes between oracle 9i,oracle 10g

2 Answers  

What is the sid in oracle?

0 Answers  

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

State some uses of redo log files?

0 Answers  

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

1 Answers   IBM,

What is the usage of save points in oracle database?

0 Answers  

what are different types of locks?

6 Answers  

Display Odd/ Even number of records?

3 Answers  

Can a field be used in a report without it appearing in any data group ?

4 Answers   Oracle,

what is the exact definition for pointer?

7 Answers   Wipro,

How to define an external table with a text file?

0 Answers