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

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

Question Posted / amedela chandra sekhar

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

chandumba2005@gmail.com

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Are null values same as that of zero or a blank space?

1028

How do I remove sql plus from windows 10?

1105

What is an implicit commit?

1058

What does data normalization mean?

972

Is primary key clustered index?

951

What is time based sql injection?

963

Enlist the data types that can be used in pl/sql?

1073

Are subqueries better than joins?

976

How does sql*loader handles newline characters in a record? : aql loader

1046

Can we join two tables without common column?

1010

What is mutating trigger?

1026

Is microsoft sql free?

1106

What is the difference between a primary key and a clustered index?

993

What is multiple columns?

1071

How much ram can sql express use?

990