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

Mention what does the hierarchical profiler does?

1088

How do I run a sql script?

1144

Can we use delete in merge statement?

1038

How can we find duplicate records in a table?

946

Are subqueries faster than joins?

1020

how to enter characters as hex numbers? : Sql dba

1041

What is Collation Sensitivity ? What are the various type ?

952

What is meant by cursor in sql?

995

Advantages and disadvantages of stored procedure?

1121

What are synonyms in sql?

970

Does sql profiler affect performance?

987

Can we write ddl statements in functions?

1116

Why is sql*loader direct path so fast?

1101

Why cross join is used?

1074

Is a foreign key always unique?

942