select * from(select ename,deptno,sal from emp order by sal desc) where row

select top 3 sal from each dept?

Question Posted / anil

Answer Posted / anil

select * from(select ename,deptno,sal from emp order by sal desc) where rownum<=3

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is bdb (berkeleydb)? : Sql dba

1090

what are string data types? : Sql dba

1093

What are pl sql data types?

1056

What does <> sql mean?

1166

Is sql a dbms?

1060

Explain the savepoint statement.

1135

what does the t-sql command ident_current does? : Transact sql

1047

How do I create a sql database?

1055

What is difference sql and mysql?

1036

what are the different type of normalization? : Sql dba

1067

What are different types of queries in sql?

1172

What normalization means?

1014

how can we find the number of rows in a table using mysql? : Sql dba

1123

What are its different types of dbms?

1053

What is the difference between function and procedure in pl/sql?

1135