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

What are types of indexes in sql?

1010

What is the difference between between and in condition operators?

940

What is PL/SQL Records?

1116

Is grant a ddl statement?

855

What is scalar data type in pl sql?

1020

What is an exception in pl/sql?

1009

What is cartesian join in sql?

1030

Which is faster count (*) or count 1?

968

What trigger means?

929

What is online transaction processing (oltp)?

962

Can procedure in package be overloaded?

1030

What is normalisation in sql?

1005

Is sql port 1433 encrypted?

974

how do you control the max size of a heap table? : Sql dba

924

How do I view a sql trace file?

961