select * from employee where salary =( select max(salary) from employee);

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

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

select * from employee where salary =( select max(salary) from
employee);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does truncate mean in sql?

1085

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1285

What is normalization? How many normalization forms are there?

1141

What are crud methods?

1086

What is primary key secondary key alternate key candidate key?

1087

How sql query is executed?

1187

What is minus?

1052

What is varchar example?

1080

What are sql data types?

1072

How do I create a sql script?

1142

Is not null in sql?

1045

What is sql*plus?

1122

How do you determine the current isolation level? : Transact sql

1206

What are the possible values for the boolean data field?

1013

Is sqlexception checked or unchecked?

1011