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

Why is theta join required?

1188

What is the source code of a program?

1118

What is left join in sql?

1091

how to use 'mysql' to run sql statements? : Sql dba

1111

What is procedure and function?

1033

How do I view a sql trace file?

1061

What is the best sql course?

1026

how tsql statements can be written and submitted to the database engine? : Transact sql

1034

Which one is better subquery or joins?

1114

Explain foreign key in sql?

1078

Is sql a backend language?

1144

Is sql procedural language?

1011

what is the difference difference between procedure and packages

10536

What are the subsets of sql?

1194

What is the basic structure of an sql?

1154