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

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

Question Posted / mohan

Answer Posted / mohan

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

or

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are set operators in sql? : Sql dba

1054

Can you selectively load only those records that you need? : aql loader

1048

What is the use of function in sql?

1095

what are dynamic queries in t-sql? : Transact sql

1024

Is sql procedural language?

967

how does a local variable is defined using t-sql? : Transact sql

1018

Does truncate table reset auto increment?

994

How to know the last executed procedure?

1099

What does the sign mean in sql?

989

How to Execute a Package in PL/SQL.?

1205

What is indexing oracle sql?

1105

What is record data type?

917

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

What is sql and db2?

1007

How to raise user-defined exception with custom sqlerrm ?

1129