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 sqlerrm?

548

What version is sql?

553

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

621

Explain what is a column in a table?

573

Explain lock escalation? : Transact sql

706

what is 'mysqlimport'? : Sql dba

574

What is Collation Sensitivity ? What are the various type ?

501

Explain the methods used to protect source code of pl/sql.

546

How do you know if a relationship is 2nf?

520

How to check if a column is nullable before setting to nullable?

584

What are different sql data types?

513

What is a primary key example?

515

Is merge a dml statement?

524

What are commit, rollback, and savepoint?

571

What are the various levels of constraints?

666