how to fine top 3 emp(sal) from each deptno i want the out put like this

What is the difference between join and union.

Question Posted / krish

27 Answers
180460 Views
3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
E-Mail Answers

Answer Posted / krish

how to fine top 3 emp(sal) from each deptno
i want the out put like this
sal deptno
100 20
200 20
300 20
150 30
250 30
350 30
so top 3 from each dept
thank u

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are secondary keys?

969

How to connect a sql*plus session to an oracle server?

1121

How to get list of all tables from a database?

1151

what is oltp (online transaction processing)? : Sql dba

1073

What does where 1/2 mean in sql?

1063

How does one use sql*loader to load images, sound clips and documents? : aql loader

1181

How do you update a value in sql?

1039

explain what is mysql? : Sql dba

1078

Can we use the cursor's to create the collection in PL/SQL?

1021

What are packages in pl sql and also explain its advantages?

1028

What is the difference between having clause and where clause?

1057

What is memory optimized?

1077

Why triggers are used?

987

What are operators available in sql?

1041

What's the difference between inner join and left join?

998