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
39761 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 / amedela chandra sekhar

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

chandumba2005@gmail.com

Is This Answer Correct ?

2 Yes

0 No

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

Answer / mayank kumar

<-- it will display max salary only-->
Select max(distinct salary)
from employee;

<-- it will display all information of employee having max salary -->

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

Is This Answer Correct ?

2 Yes

0 No

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

Answer / anil

select * from test.emp where salary=(select max(salary) from test.emp);

Is This Answer Correct ?

1 Yes

0 No

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

Answer / amit kumar agarwalla

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mrityunjay singh

select *from employees where rownum<2 order by salary desc;
or
select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mohan

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

or

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / pree

Select name,salary from Employee where salary in(select max
(salary)
from Employee );

Is This Answer Correct ?

0 Yes

0 No

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

Answer / apsar

select * from (select e.* from emp order by e.sal desc)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / dinesh kumar

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sandeep

Select * from employee where rownum=1 order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer