Select * from Employee where sal = (select max(sal) frpm Employee)

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

Question Posted / pradeep sahoo

Answer Posted / pradeep sahoo

Select * from Employee where sal = (select max(sal) frpm
Employee)

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I save the results of sql query in a file?

533

How is data stored in sql?

547

Explain the select statement in sql?

611

What is trigger in pl sql?

555

What is normalization in a database?

610

How to make a copy values from one column to another in sql?

572

What is indexes?

540

How is pl sql different from sql?

540

what is an extent ? : Sql dba

580

How to create your own reports in sql developer?

536

What can sql server reporting services do?

577

Write a query to display the current date in sql?

511

Is sql dba a good career? : SQL DBA

529

What are the differences between in and exists clause?

564

How do you update a table in sql?

516