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

How delete a row in sql?

995

Is sql scripting language?

1055

What are sql commands?

1013

what is 'mysqlcheck'? : Sql dba

1015

Is sql port 1433 encrypted?

1024

Explain the rollback statement?

1013

List the ways to get the count of records in a table?

900

Explain how exception handling is done in advance pl/sql?

999

What is an emotional trigger?

1005

How do I run a script in sql developer?

950

How do I kill a query in postgresql?

1129

Can we call stored procedure in function?

959

Explain polymorphism in pl/sql.

1123

What are triggers and its types?

1062

What is rollback?

1115