select * from employee where salary =( select max(salary) from employee);

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

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

select * from employee where salary =( select max(salary) from
employee);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

539

How do I run a sql trace?

522

What are the uses of sysdate and user keywords?

631

Does inner join return duplicate rows?

521

What is an exception in PL/SQL? What are the two types of exceptions?

629

How do you update a table in sql?

519

What is anonymous block in sql?

640

How subquery works in sql?

543

How to fetch alternate records from a table?

684

Can primary key be changed?

529

What are the most important ddl statements in sql?

577

What is trigger explain with example?

552

Is pl sql and postgresql same?

573

What are the advantages of pl sql over sql?

548

Explain commit, rollback and savepoint.

607