From an Employee table, how will you display the record
which has a maximum salary?
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 |
Post New Answer View All Answers
What is string join?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is crud stand for?
What is where clause in sql?
Can we call a function containing dml statements in a select query?
how to check server status with 'mysqladmin'? : Sql dba
how many groups of data types? : Sql dba
Is it possible to pass parameters to triggers?
when MSQL8.0 is in market
What is latest version of sql?
How to call shell script from pl sql procedure?
What is asqueryable?
What is the command used to fetch first 5 characters of the string?
Which join is default?
what is the difference between char and varchar data types? : Sql dba