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

How do you update a value in sql?

547

What does varchar include?

517

Explain what is sql?

604

What are pl sql procedures?

510

what is foreign key? : Sql dba

583

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

538

what are the advantages a stored procedure? : Sql dba

543

Why do we need databases?

565

What is before and after trigger?

518

What is the basic structure of an sql?

567

What is blind sql injection?

572

What is exception? What are the types of exceptions?

552

Define commit, rollback and savepoint?

571

Can we use rowid as primary key?

539

What are the basic techniques of indexing?

570