select top 3 sal from each dept?

Answer Posted / sen

select *
(select sal from emp
order by 1 desc)
where rownum < 4

Is This Answer Correct ?    1 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2097


What are different functions in sql?

519


What is difference between mysql and postgresql?

519


The in operator may be used if you know the exact value you want to return for at least one of the columns.

558


What are operators available in sql?

591






Which constraints we can use while creating database in sql?

619


When sql appeared?

623


Explain the difference between drop and truncate commands in sql?

537


how to use case expression? : Sql dba

556


What packages(if any) has oracle provided for use by developers?

5038


Can we connect to postgresql using sql developer?

490


what is sql server agent? : Sql dba

605


How do you truncate?

507


What is trigger in pl sql with examples?

525


How long it takes to learn pl sql?

533