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 string join?

559

Are there any features that are decommissioned in 11g that are not present in 11g?

1595

What is crud stand for?

570

What is where clause in sql?

537

Can we call a function containing dml statements in a select query?

547

how to check server status with 'mysqladmin'? : Sql dba

573

how many groups of data types? : Sql dba

569

Is it possible to pass parameters to triggers?

575

when MSQL8.0 is in market

1604

What is latest version of sql?

528

How to call shell script from pl sql procedure?

625

What is asqueryable?

533

What is the command used to fetch first 5 characters of the string?

887

Which join is default?

522

what is the difference between char and varchar data types? : Sql dba

543