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

Does inner join return duplicate rows?

925

what is the functionality of the function htmlentities? : Sql dba

890

when MSQL8.0 is in market

2012

Can you rollback after commit?

930

Why do we use procedures?

909

Can sql function call stored procedure?

955

What is interval partition?

979

What is the cause of mutating table error and how can we solve it?

988

What is numeric function sql?

982

what are the different tables present in mysql? : Sql dba

922

Explain the types of joins in sql?

958

Can a foreign key be a duplicate?

858

what is timestamp in mysql? : Sql dba

998

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

Define implicit and explicit cursors.

1071