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 / debjani chakraborty

Answer Posted / debjani chakraborty

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

Is This Answer Correct ?

58 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why is a trigger used?

950

What does varchar include?

956

What are actual parameters and formal parameters?

1112

What do you mean by table in sql?

999

Is join an inner join?

981

What is the default isolation level in sql server? : Transact sql

1040

What is full join?

961

What are local and global Indexes and where they are useful.

1449

What are types of indexes in sql?

1092

Can we rollback after truncate?

1035

Can a table contain multiple primary key’s?

1108

Explain the rollback statement?

1016

Does group by remove duplicates?

1048

How to display the current date in sql?

1086

What is memory optimized?

1093