select top 1 Name from emp order by sal desc

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / lince

Answer Posted / lince

Is This Answer Correct ?

8 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is backup in Oracle?

1006

What are the different editions of oracle?

1110

How to create a table interactively?

1097

What is a read only transaction in oracle?

1029

How to drop an existing view in oracle?

947

Difference between cartesian join and cross join?

1050

How does oracle handle read consistency?

1100

Explain the use of parfile option in exp command.

1070

How to grant create session privilege to a user in oracle?

1004

What happens if the imported table already exists?

1033

Write a trigger example in oracle?

1068

What are the various types of snapshots ?

1030

Point the difference between translate and replace?

1095

List out the components of logical database structure of oracle database.

1039

what happened to the global index when I truncate the data in one of the partition?

2024