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

15 Answers
16044 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to resolve name conflicts between variables and columns?

1031

What is a proxy class?

1055

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

How to work with data objects interactively?

984

What is set operator oracle?

981

What is system tablespace?

1098

what is a Nested Loop join?

2117

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

What is enter substitution variable in oracle?

1052

Please explain drop constraint oracle?

1108

What is the difference between sharding and partitioning?

986

What are the most common interview questions on ETL Testing for experience?

1144

What is Data Dictionary Cache in Oracle?

1165

How to select some rows from a table in oracle?

1078

How to display row numbers with the records?

1080