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 are advantages of dateset in datastage?

2199

Explain the use of full option in exp command.

1055

What is the dynamic sql in oracle?

1007

When do you get a .pll extension in oracle? Explain its importance

985

Explain enable novalidate constraint.

1031

Explain drop constraint oracle?

989

What do you mean by group by clause?

977

How to rename a column in an existing table?

972

What are the restrictions on external table columns?

991

What is the difference between substr & instr functions?

1120

How to retrieve the count of updated rows?

1054

please explain.. DB architecture ...

1966

What are the different editions of oracle?

1048

What is procedure overloading in oracle?

992

How does Oracle guarantee data integrity of data changes?

2331