select a.ename from (select ename from emp ORDER BY SAL desc,ROWNUM DESC)

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

Question Posted / neha

Answer Posted / neha

select a.ename from (select ename from emp ORDER BY SAL
desc,ROWNUM DESC)a
where rownum=1;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Compare and contrast between sql and sql server and explain its various functions?

1018

What is a system tablespace and when it is created?

1016

How to handle a single quote in oracle sql?

1097

How to test null values?

1156

How can windows applications connect to oracle servers?

1116

11. Display the client number and name and the client number and name of the person who referred that client.

2390

Explain what are synonyms used for?

1094

Difference between pre-select and pre-query

1175

How to use group functions in the select clause using oracle?

1133

Does oracle charge for java?

1115

What is the difference between primary key and unique key and foreign key in oracle?

1036

What is set verify off in oracle?

1158

interview questions with answer for cts

2636

What is Undo Management Advisor in Oracle?

1152

Is oracle an open source?

1127