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
39057 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 / hari

select max(sal) from employee;
or
select * from employee where sal in(select max(sal) 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 / venubabu addagada

SELECT DISTINCT
( e.emp_salary )
FROM
employee e
WHERE
&n = (
SELECT
COUNT(DISTINCT(e1.emp_salary) )
FROM
employee e1
WHERE
e1.emp_salary > e.emp_salary
);

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sudeep mishra

select *
from employee
where salary = max sal

Is This Answer Correct ?

0 Yes

1 No

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

Answer / senthilkumar

SELECT MAX(SAL)AS MAXIMUMSALARY FROM EMP

Is This Answer Correct ?

1 Yes

3 No

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

Answer / suresh babu

SELECT * FROM employees WHERE salary = (SELECT MAX(salary)
FROM employees);

This query will return the employee details,who getting
maximum salary.

Is This Answer Correct ?

0 Yes

2 No

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

Answer / suma

SELECT emp_name, salary FROM EMPLOYEES E1
WHERE (0) = (SELECT COUNT(DISTINCT(E2.salary))
FROM EMPLOYEES E2
WHERE E1.salary < E2.salary)

Is This Answer Correct ?

13 Yes

16 No

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

Answer / royals

select max (esal) as maximumsal from employee;

Is This Answer Correct ?

5 Yes

10 No

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

Answer / jayshree

SELECT LAST_NAME,MAX(SALARY)
FROM EMPLOYEES
GROUP_BY SALARY;

Is This Answer Correct ?

2 Yes

8 No

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

Answer / sanjeev

select max(sal) from emp

Is This Answer Correct ?

5 Yes

14 No

Post New Answer