Select * from Employee where salary in(select max(salary) from Employee)

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / sharmila

Answer Posted / sharmila

Select * from Employee where salary in(select max(salary)
from Employee)

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is percent sign in sql?

1283

What are the different types of triggers?

1136

What is dynamic query?

974

What has stored procedures in sql and how we can use it?

1082

What is the purpose of primary key?

1026

How can you load multi line records? : aql loader

1076

What is difference between pl and sql?

1058

How do you remove duplicates without using distinct in sql?

976

What is composite data type in pl sql?

1109

What does sign mean sql?

1111

What are all the common sql functions?

1025

What is informix sql?

975

What is program debugging?

1248

What is cartesian join in sql?

1128

What is an implicit commit?

1053