From an Employee table, how will you display the record
which has a maximum salary?
Answers were Sorted based on User's Feedback
Answer / debjani chakraborty
Select * from Employee where salary in(select max(salary)
from Employee);
Is This Answer Correct ? | 58 Yes | 2 No |
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 |
Answer / pradeep sahoo
Select * from Employee where sal = (select max(sal) frpm
Employee)
Is This Answer Correct ? | 25 Yes | 1 No |
Answer / sharmila
Select * from Employee where salary in(select max(salary)
from Employee)
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / aruna parulekar
select * from employee where sal=(select max(sal) from
employee);
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / kvsd
select * from employees where salary = (select max(salary)
from employees)
Is This Answer Correct ? | 5 Yes | 1 No |
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 |
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 |
What is trigger and types?
what are rollup and cube in t-sql? : Transact sql
how to install mysql? : Sql dba
List the different type of joins?
What is the difference between in and between in sql?
How long it takes to learn pl sql?
how can we submit a form without a submit button? : Sql dba
Which are sql * plus commands?
Explain how to use transactions efficiently : transact sql
Can a view be mutating? If yes, then how?
how to present a past time in hours, minutes and seconds? : Sql dba
What are the types of views in sql?