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

What is primary key and foreign key with example?

936

What is trigger in sql? Explain

999

How do I tune a sql query?

981

What does rownum mean in sql?

1034

Can delete statement be rollbacked?

991

What is set transaction?

1044

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1013

What is sql engine in oracle?

995

Which command is used to delete a package?

1179

What are records give examples?

1014

How do you add a column to a table?

1062

What are the most important characteristics of pl/sql?

1165

Are sql database names case sensitive?

1010

how to create a new view in mysql? : Sql dba

943

What is difference between pl and sql?

1068