From an Employee table, how will you display the record which has a maximum sa

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / ss321

29 Answers
39759 Views
Cap Gemini, Exilant, Synechron, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

From an Employee table, how will you display the record which has a maximum salary?..

Answer / debjani chakraborty

Select * from Employee where salary in(select max(salary)
from Employee);

Is This Answer Correct ?

58 Yes

2 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / kavitha nedigunta

select * from emp e,(select max(sal) sal
from emp)a
where e.sal= a.sal;

select * from emp
where sal in(select max(sal) from
emp);

Is This Answer Correct ?

29 Yes

3 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / pradeep sahoo

Select * from Employee where sal = (select max(sal) frpm
Employee)

Is This Answer Correct ?

25 Yes

1 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / sharmila

Select * from Employee where salary in(select max(salary)
from Employee)

Is This Answer Correct ?

13 Yes

1 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / aruna parulekar

select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?

14 Yes

2 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / sharmila

select emp_name,max(salary)
from Employee.

Is This Answer Correct ?

55 Yes

44 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / kvsd

select * from employees where salary = (select max(salary)
from employees)

Is This Answer Correct ?

5 Yes

1 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / sayed

select top(1) * from emp order by salary desc

Is This Answer Correct ?

4 Yes

1 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / os reddy

select * from emp
where sal=(select max(sal) from emp);

OR

select * from emp
where sal in(select max(sal) from emp);

Is This Answer Correct ?

4 Yes

1 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / pradeep

To get nth rank salary or max salary two ways

below 5th

select ct , empno, sal from (SELECT max(rownum) ct , empno,
sal FROM emp group by empno, sal ORDER BY sal desc) where
ct =5;

below 2nd

select * from (
SELECT DEPTNO,ENAME,SAL,COMM,
RANK() OVER ( ORDER BY SAL DESC, COMM) poK from emp)
where pok =2;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer