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

What is a composite primary key?

1099

How do you write a subquery?

1034

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

980

What is partition by in sql?

1074

Is it possible to update views?

964

How to install oracle sql developer?

1056

What does inner join mean?

1177

What is the use of index in sql?

1020

Which sorts rows in sql?

1025

What are analytic functions in sql?

1034

How to select all records from the table?

1141

explain what is mysql? : Sql dba

1088

What is the difference between python and sql?

1010

Is a view faster than a stored procedure?

976

Can we use rowid as primary key?

992