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

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

Question Posted / mohan

Answer Posted / mohan

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

or

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statement in sql?

1007

how to show all tables with 'mysql'? : Sql dba

1058

What are the different parts of a package?

1039

what is collation? : Sql dba

1077

What is sqlcontext?

979

what are the authentication modes in sql server? : Sql dba

996

Why do you partition data?

962

How to start the command-line sql*plus?

996

Is sql scripting language?

972

What is sql and explain its components?

1006

How do I write a sql query in pgadmin 4?

923

how to use like conditions? : Sql dba

1036

How does postgresql compare to oracle/db2/ms sql server/informix?

980

Can we rollback truncate?

940

Where is all the data on the internet stored?

947