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 does a local variable is defined using t-sql? : Transact sql

546

What is left inner join in sql?

519

What does stand for in sql?

524

What are aggregate and scalar functions?

527

what are properties of a transaction? : Sql dba

561

How do I remove sql plus from windows 10?

568

What is sql in oracle?

625

What are the different schemas objects that can be created using pl/sql?

530

Can we use join in subquery?

567

How delete all data from all tables in sql?

540

What is a unique key?

588

What view means?

558

What are tuples in sql?

569

What is cost in sql execution plan?

490

What are the datatypes available in pl/sql ?

614