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

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

Question Posted / amit kumar agarwalla

Answer Posted / amit kumar agarwalla

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to dump a table to a file with 'mysqldump'? : Sql dba

983

Does sql use python?

978

What is case function?

989

How do I turn a list into a table?

910

How many tables can you join in sql?

901

How do you drop a trigger?

924

what is bcp? When does it used? : Sql dba

935

How to execute a stored procedure?

1037

Does sql require a server?

945

What is sql not null constraint?

983

what is the difference between cluster and non cluster index? : Sql dba

958

What is sql indexing?

965

What are the packages in pl sql?

968

What is count * in sql?

937

How to pipe multiline string to isql?

961