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

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

Question Posted / suresh babu

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

Please Help Members By Posting Answers For Below Questions

Can a table contain multiple primary key’s?

631

When is the explicit cursor used ?

591

What are sql data types?

549

Why trigger is used in sql?

534

What is bulk collect in pl sql?

535

What is pl sql package?

598

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

540

explain about mysql and its features. : Sql dba

554

What is the difference between joins?

536

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

549

What is rtm in testing?

578

what are the non-standard sql commands supported by 'mysql'? : Sql dba

573

Does pl/sql support create command?

578

How sql query is executed?

559

what is the difference between a having clause and a where clause? : Sql dba

521