select sal from (select distinct sal from emp order by sal desc) where

how to retrieve the top 3 salaries of the table using rownum

Question Posted / chiru

Answer Posted / chiru

select sal from (select distinct sal from emp order
by sal desc)
where rownum<4 ;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the left table in sql?

915

explain advantages of myisam over innodb? : Sql dba

1017

What are the types of subqueries?

1018

What view means?

931

What is meant by truncate in sql?

1008

What is the purpose of a sql?

915

What is a trigger in sql?

1158

how would you enter characters as hex numbers? : Sql dba

939

Can we use rowid as primary key?

944

What is the difference between subquery and correlated query?

991

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2172

What is a variable in sql?

953

What is sql catalog?

964

What are the parts of a sql statement?

1030

What is pl sql script?

979