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

How can use stored procedures in sql?

1190

What is the difference between partition and index?

1054

What are the types of sql commands?

1154

what are set operators in sql? : Sql dba

1104

How do I save the results of sql query in a file?

1010

How do I save a sql query?

1066

How do I run a sql query in pgadmin 4?

999

Can a primary key be a foreign key?

1079

What are different functions in sql?

998

Are null values same as that of zero or a blank space?

1064

What are user defined functions?

1061

How does left join work in sql?

1036

Mention what does the hierarchical profiler does?

1136

What is a primary key example?

1000

What makes a good primary key?

1093