SELECT emp_name, salary FROM EMPLOYEES E1 WHERE (0) = (SELECT COUNT(DISTIN

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

Question Posted / suma

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is index example?

1013

What is dml with example?

1093

How to read xml file in oracle pl sql?

914

What do you understand by case manipulation functions?

1035

What is duration in sql profiler trace?

1085

Does sql require a server?

1019

How do sql databases work?

1003

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1069

how would you get the current date in mysql? : Sql dba

969

How do you truncate?

913

Which function is used to return remainder in a division operator in sql?

1143

Is it possible to sort a column using a column alias?

1052

What is record in pl sql?

1086

what is view? : Sql dba

970

What is a sql*loader control file?

1271