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...

Dept wise avrage salary

Answer Posted / suraj

select deptno,trunc(avg(sal))as avg from emp group by deptno;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages and disadvantages of views in the database?

1023


Why c++ used in clipper?

885


What are databases what are the uses of databases?

880


What is the biggest advantage of rdbms?

1010


What are the characteristics of data in the database?

932


How do you handle your own transaction?

974


Is there a database program for mac?

900


What are codd rules?

934


How to move a multi-file database?

1003


What is a system concept?

876


What is a Built_in subprogram ?

3953


What is trigger in dbms?

885


What are the 4 types of database?

990


What are the properties of a primary key in DBMS?

922


What is rank in database?

843