Select * from Employee where sal = (select max(sal) frpm Employee)

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / pradeep sahoo

Answer Posted / pradeep sahoo

Select * from Employee where sal = (select max(sal) frpm
Employee)

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many rows can sqlite handle?

1069

What is the difference between sql and mysql?

1075

What does the base_object_type column shows in the user.triggers data dictionary view?

1013

What are tuples in sql?

1085

what is a relationship and what are they? : Sql dba

1062

What is the max nvarchar size?

920

What is the command used to fetch the first 5 characters of a string?

1179

Why do we need a foreign key?

1045

what is foreign key? : Sql dba

989

Differentiate between syntax and runtime errors.

1142

What's the procedure?

888

What is sqlite used for?

956

What is normalisation in sql?

1021

What are the topics in pl sql?

948

How to fetch alternate records from a table?

1183