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 / kvsd

Answer Posted / kvsd

select * from employees where salary = (select max(salary)
from employees)

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is oracle sql developer?

994

Why we use triggers in mysql?

938

Explain exception handling in pl/sql?

990

List the different type of joins?

1004

Can ddl statements be used in pl/sql?

1070

Is postgresql a nosql database?

1079

Can unique keys be null?

853

What are two statement types in sql?

1033

Differentiate between pl/sql and sql?

1073

What is string data type in sql?

1055

How to run sql statements with oracle sql developer?

1000

Explain what is sql?

1062

What is orm in sql?

995

Which normal form is best?

896

What is percent sign in sql?

1215