select * from emp where sal=(select max(sal) from emp); OR

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

Question Posted / os reddy

Answer Posted / os reddy

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

OR

select * from emp
where sal in(select max(sal) from emp);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

1113

Is sqlite free?

1022

What is a system versioned table?

1039

What is query syntax?

1018

What are the different types of dbmss?

1054

What if we write return in procedure?

1510

What are some emotional triggers?

1033

how to convert character strings to numeric values? : Sql dba

1162

how to create a table index in mysql? : Sql dba

1118

How does sql developer connect to oracle database?

1049

What is the difference between sql and isql*plus?

1160

what is the difference between $message and $$message? : Sql dba

1039

What does closing a cursor do?

1372

Explain sql data types?

1143

Is coalesce faster than isnull?

1011