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

explain primary keys and auto increment fields in mysql : sql dba

912

What type of database is sql?

994

how to get a list of indexes of an existing table? : Sql dba

939

How can we solve sql error: ora-00904: invalid identifier?

1196

Explain what is sql?

1079

What is the limitation on the block size of pl/sql?

961

what are the differences between binary and varbinary? : Sql dba

1004

What is sql dialect?

1065

Does google use sql?

924

What is int identity in sql?

1085

How do I remove duplicates in two columns?

1011

How to convert comma separated string to array in pl/sql?

1140

What is difference between ms sql and mysql?

932

What is sql partition?

1061

What is rename in sql?

938