select top 3 sal from each dept?

Answer Posted / avinesh gupta

select top 3 sal,depno from emp where deptno in
(
select deptno from emp group by deptno
)
order by sal desc

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does <> sql mean?

542


Where the sql database files are stored?

496


what is acid property in database? : Sql dba

561


What is cost in sql execution plan?

490


Differentiate between syntax and runtime errors.

642






How to run sql statements through the web interface?

514


Can a varchar be a primary key?

538


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

558


Is primary key a clustered index?

537


What is compound trigger?

561


How can a pl sql block be executed?

531


What is not equal in sql?

511


How to write pl sql program in mysql command prompt?

521


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

528


What is optimistic concurrency control? : Transact sql

553