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)

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,

How much memory your 10g xe server is using?

0 Answers  

How do I spool in oracle?

0 Answers  

Is truncate autocommit in oracle?

0 Answers  

How to define an anonymous procedure with variables?

0 Answers  

How to pass a parameter to a cursor in oracle?

0 Answers  

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

When do I need to use a semicolon vs a slash in oracle sql?

0 Answers  

Give the Types of modules in a form?

1 Answers  

How to use "in" parameter properly?

0 Answers  

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,