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

Why do we need unique key in a table?

882

What is database white box testing and black box testing?

1045

What are the subsets of sql?

1032

what is bdb (berkeleydb)? : Sql dba

969

What is difference between primary and secondary key?

972

Why is sharding used?

938

How do you remove duplicates without using distinct in sql?

918

which operator is used in query for pattern matching? : Sql dba

946

Define a temp table?

961

What is aggregate function in sql?

983

How do you declare a variable in pl sql?

964

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

Which table is left in left join?

951

What is a sql instance vs database?

1034

What is a join?

1019