select top 3 sal from each dept?

Answer Posted / kishore

select * from (
select sal,rownum as num from (select sal from
emp order by sal desc))
where num <=3;

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the join types in tsql? : Transact sql

576


What are the different parts of a package?

635


How many sql statements are used? Define them.

576


Difference between truncate, delete and drop commands?

559


How can we debug in PL/SQL?

663






Differentiate between % rowtype and type record.

735


What are sql functions? Describe the different types of sql functions?

561


What is an escape character in sql?

566


Can function return multiple values in sql?

533


how to do backup entire database? : Transact sql

618


what is blob? : Sql dba

564


Does mysql support pl sql?

624


How do I sort a table in sql?

599


What is the current version of postgresql?

560


How does a self join work?

520