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

What are all the common sql functions?

1016

What is server name sql?

1141

What are the different types of constraints?

1177

How many parts of a pl sql block are optional?

1130

Explain what is a column in a table?

1107

Whis is not false in primary key?

1454

Can we use the cursor's to create the collection in PL/SQL?

1025

What are different types of functions in sql?

1004

What is the difference between union and union all command?

1088

How do you take the union of two tables in sql?

985

What are hotfixes and patches?

946

Does db2 use sql?

945

What is a temporal table?

928

Can we join 3 tables in sql?

1037

Is delete faster than truncate?

1002