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

How much does sql certification cost?

1142

What are different types of keys?

1174

What is triggering circuit?

1105

What is a file delimiter?

1164

Does view store data in sql?

1042

How to get unique records from a table?

1022

how to include numeric values in sql statements? : Sql dba

1149

Is primary key is clustered index?

1045

What are sql built in functions?

981

Is drop table faster than truncate?

1049

Can a procedure in a package be overloaded?

1102

Define concurrency control. : Transact sql

1236

How to Declare Fixed Length String Value In PL SQL

1207

What is difference between joins and union?

1195

What is program debugging?

1343