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

How many sql databases can you have on one server?

1153

Can a foreign key be a duplicate?

963

What is t sql in sql server?

1132

What is anonymous block in sql?

1173

What is data profiling in sql?

1138

describe transaction-safe table types in mysql : sql dba

1060

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1019

Does truncate table reset auto increment?

1050

Can we commit inside a trigger?

1047

What is percent sign in sql?

1325

What does a pl/sql package consist of?

1016

What is the difference between cross join and natural join?

1067

Explain exception handling in pl/sql?

1083

What are the syntax and use of the coalesce function?

1275

Is mariadb nosql?

1091