select * from employees where salary = (select max(salary) from employees

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

Question Posted / kvsd

Answer Posted / kvsd

select * from employees where salary = (select max(salary)
from employees)

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

is it possible to pass an object or table to a procedure as an argument?

564

what are the differences between binary and varbinary? : Sql dba

529

What is pl sql block structure?

535

What is sql scripting?

555

Can we join more than 2 tables in sql?

489

What is rownum?

536

What does sql stand for?

540

what is union? : Sql dba

580

What is sql performance tuning?

492

What are tuples in sql?

559

How do I view a sql database?

552

What is delimiter sql?

541

How do I find duplicates in two columns?

548

Is coalesce faster than isnull?

500

How to select 10 records from a table?

641