find out first highest salary?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / guest

10 Answers
16434 Views
Verinon Technology Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find out first highest salary?..

Answer / la

select max(sal) from emp;

Is This Answer Correct ?

15 Yes

2 No

find out first highest salary?..

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

Is This Answer Correct ?

9 Yes

0 No

find out first highest salary?..

Answer / chandiran

select max(sal) from Employee

Is This Answer Correct ?

7 Yes

0 No

find out first highest salary?..

Answer / samir kumar sahoo

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

Is This Answer Correct ?

6 Yes

2 No

find out first highest salary?..

Answer / ela tiku

select max(sal) from emp

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

Is This Answer Correct ?

4 Yes

0 No

find out first highest salary?..

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);

Is This Answer Correct ?

5 Yes

2 No

find out first highest salary?..

Answer / mak

it's right

Is This Answer Correct ?

3 Yes

1 No

find out first highest salary?..

Answer / o p yadav

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

Is This Answer Correct ?

2 Yes

0 No

find out first highest salary?..

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

Is This Answer Correct ?

1 Yes

0 No

find out first highest salary?..

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)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer