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

Does pl/sql support create command?

1065

what are the features and advantages of object-oriented programming? : Sql dba

979

what is a primary key? : Sql dba

1009

What are the different ddl commands in sql?

1091

What are the rules to be applied to nulls whilst doing comparisons?

1297

How many types of functions are there in sql?

911

What is trigger types of trigger?

1016

What does the sign mean in sql?

945

What are the types of index in sql?

1036

Is mariadb nosql?

1012

Does inner join return duplicate rows?

947

What are expressions?

972

What is difference between joins and union?

1074

What is a call statement? Explain with an example.

974

What is autocommit sql?

949