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 commit? : Sql dba

1029

What is the difference between function, procedure and package in pl/sql?

1138

Explain what is rdbms?

993

What does varchar include?

908

How many types of functions are there in sql?

899

What are tuples in sql?

1064

Why join is faster than subquery?

1048

What are % type and % rowtype?

983

What is the most important ddl statements in sql are?

947

What has stored procedures in sql and how we can use it?

1017

how to get a list of all tables in a database? : Sql dba

922

How do you define a foreign key?

941

What is compute?

1016

What is difference between sql and oracle?

1050

What is the difference between sql and isql*plus?

1007