select * from emp where sal=(select max(sal) from emp); OR

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

Question Posted / os reddy

Answer Posted / os reddy

select * from emp
where sal=(select max(sal) from emp);

OR

select * from emp
where sal in(select max(sal) from emp);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is difference between left and right outer join?

931

Which tcp/ip port does sql server run?

955

What is pl/sql table? Why is it used?

976

Where is all the data on the internet stored?

947

What is a delimiter in sas?

974

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966

what are the type of locks ? : Sql dba

896

What is difference between sql and oracle?

1046

What are the two parts of design view?

971

What is input buffer in sql*plus?

1121

What is an emotional trigger?

927

how many columns can be used for creating index? : Sql dba

893

Is sql scripting language?

972

Does a primary key have to be a number?

915

What are user defined functions?

946