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 is a database event trigger?

1211

What is sql and db2?

1054

What is trigger types in sql?

1044

Is it possible to pass parameters to triggers?

1161

What is an escape character in sql?

1073

What is the difference between sql and mysql?

1179

What does rownum mean in sql?

1090

Is oracel sql developer written in java?

1169

What is the difference between partitioning and sharding?

1051

What is raw datatype in sql?

1106

What is set transaction?

1090

What is lookup table in sql?

1092

how to get a list of indexes of an existing table? : Sql dba

1006

Can we use rowid as primary key?

1044

Explain correlated query work?

1107