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 is the difference between view and stored procedure?

964

How do I run a sql script?

1161

Why we use sql profiler?

963

Where the sql database files are stored?

1025

what is data manipulation language? : Sql dba

1026

what is the difference between nested subquery and correlated subquery?

1060

Is left join and outer join same?

1080

How do I order by ascending in sql?

1029

Where is pl sql used?

958

What are sql ddl commands?

1101

What information is needed to connect sql*plus an oracle server?

1034

how to install mysql? : Sql dba

1119

What is primary key secondary key alternate key candidate key?

1037

How are functions and procedures called in PL/SQL?

1241

What is the limitation on the block size of pl/sql?

996