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

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1053

what is 'mysqlcheck'? : Sql dba

1064

What is the main difference between sql and pl/sql?

1149

how to increment dates by 1 in mysql? : Sql dba

1034

What is posting?

1084

What view means?

1025

How to select 10 records from a table?

1207

What is scalar function?

1096

What's the difference between a primary key and a clustered index?

1026

What are the three pl sql block types?

1049

What is a primary key? Explain

1024

Which is better join or subquery?

1190

what is a tablespace? : Sql dba

1102

Can we enter data in a table in design view?

1013

What are the three forms of normalization?

1092