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 are the steps for performance tuning.

1337

Explain what is an index?

1056

What is primary key and unique key?

1121

What is the process of debugging?

1070

Which command is used to delete a package?

1173

How many postgresql users are there, worldwide?

1061

What is the location of pre_defined_functions.

1166

Does sql*plus also have a pl/sql engine?

1079

How to select unique records from a table?

1059

Why is sharding used?

995

What are reports usually used for?

1023

What is sql query optimization?

1116

What are the packages in pl sql?

1009

What is an emotional trigger?

1005

Define concurrency control. : Transact sql

1191