select * from employee where sal=(select max(sal) from employee);

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

Question Posted / aruna parulekar

Answer Posted / aruna parulekar

select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is varchar used for?

1085

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1040

Explain the working of foreign key?

1071

What is data control language (dcl)?

1146

Does pl sql work in mysql?

986

How to pipe multiline string to isql?

1009

what are the security recommendations while using mysql? : Sql dba

1124

What is %rowtype in pl sql?

994

What does := mean in pl sql?

1047

Which are the different types of indexes in sql?

1063

What does select * from mean in sql?

3247

How can we make an if statement within a select statement?

1017

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172

how to get a list of columns in an existing table? : Sql dba

966

How do you delete duplicates in sql query using rowid?

950