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

What is primary key and foreign key?

917

where are cookies actually stored on the hard disk? : Sql dba

977

how many sql ddl commands are supported by 'mysql'? : Sql dba

959

when MSQL8.0 is in market

2016

How do you modify a column in sql?

943

How exception is different from error?

971

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

what is the difference between nested subquery and correlated subquery?

988

What is #table in sql?

997

Can we join more than 2 tables in sql?

950

What is difference between sql and mysql?

1065

Which normal form is best?

895

What is sql select statement?

971

What is nvarchar max in sql?

960

What is trigger point?

950