Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between join and union.

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

How insert into statements in sql?

1012


What are transaction and its controls?

971


Is sqlite good enough for production?

953


What is clustered index sql?

942


What is the most restrictive isolation level? : Transact sql

1028


Which one is faster ienumerable or iqueryable?

867


What is the difference between pl and sql?

1040


What are the two types of periodical indexes?

889


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1076


Define implicit and explicit cursors.

1078


Should I use mbr or gpt?

951


The select into statement is most often used to create backup copies of tables or for archiving records?

1003


What are the different types of constraints?

1078


What does data normalization mean?

902


what is a constraint? : Sql dba

1106