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

Explain the purpose of %type and %rowtype data types with the example?

955

Explain the difference between 'between' & 'and' operators in sql

965

What is before trigger?

962

How does an execution block start and end in pl sql?

916

What is difference between stored procedure and trigger?

1090

how do you control the max size of a heap table? : Sql dba

950

what is the difference between delete and truncate commands? : Sql dba

1015

What are the benefits of triggers?

1133

Does view store data in sql?

924

What is composite primary key in sql?

959

How do rank () and dense_rank () differ?

998

Write a sql query to find the names of employees that begin with ‘a’?

972

Can you have more than one key in a database?

905

What is the use of index in sql?

978

Which is faster joins or subqueries?

950