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 we alter stored procedure?

1043

What does pragma mean?

1131

What are operators available in sql?

1095

What are synonyms in sql?

1019

How to use boolean type in select statement?

1139

How do I debug a stored procedure?

1171

what are the join types in tsql? : Transact sql

1105

How do I remove all records from a table?

1117

In pl/sql, what is bulk binding, and when/how would it help performance?

1035

Can sql developer connect to db2?

1104

Why do we use sqlite?

1029

How to change the order of columns in Oracle SQL Plus ?

1102

What is a left join?

1007

What is the difference between drop and truncate commands?

1111

What are the types of records?

1038