select max(sal) from employee; or select * from employee where s

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

Question Posted / hari

Answer Posted / hari

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I view a table in sql?

1006

What is a table?

1014

What is query execution plan in sql?

1186

What is pessimistic concurrency control? : Transact sql

1086

what are date and time intervals? : Sql dba

1057

how can we know the number of days between two given dates using mysql? : Sql dba

1048

What is the benefit of foreign key?

1022

What is constant in pl sql?

1022

Is vs as in pl sql?

984

Is sqlite free?

970

How do you modify a column in sql?

995

what are the drivers in mysql? : Sql dba

1019

List out the acid properties and explain?

949

what are the disadvantages of mysql? : Sql dba

1149

Does oracle roll back the transaction on an error?

1013