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)

Explain the use of constraints option in exp command.

0 Answers  

how many columns can a plsql table have

13 Answers   NIIT,

What are the various oracle database objects?

0 Answers  

What is null value in oracle?

0 Answers  

What is SQL access advisor in Oracle?

0 Answers   MCN Solutions,

How to create id with auto_increment on oracle?

0 Answers  

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

Can multiple cursors being opened at the same time?

0 Answers  

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

What is raw datatype in oracle?

0 Answers  

How to update values in a table in oracle?

0 Answers  

What is system tablespace?

0 Answers