select * from emp e where &n=(select count(distinct Sal)from emp where

select top 3 sal from each dept?

Question Posted / ramireddy

Answer Posted / ramireddy

select * from emp e where &n=(select count(distinct Sal)from
emp where Sal<=e.Sal);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql exception?

1012

What is the maximum number of rows in sql table?

1079

Does sap use sql?

1041

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1077

What is rank dense_rank and partition in sql?

1086

How do I filter in sql profiler?

1055

What is primary and foreign key?

1123

What is a scalar value in sql?

1123

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1244

explain primary keys and auto increment fields in mysql : sql dba

1017

What is native sql query?

1076

Does sql*plus have a pl/sql engine?

1129

What is set serveroutput on in pl sql?

1360

Can a table contain multiple foreign key’s?

1054

What is sqlca in powerbuilder?

1067