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

Enlist the various transaction phases.

1099


Why are recursive relationships are bad? How do you resolve them?

1195


Can videos be stored in a database?

1001


What do you understand by index hunting?

1195


what are the different kinds of indexing?

1068


Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1880


What do you mean by durability in dbms?

1098


Have you heard about sixth normal form?

1064


In which format data is stored in database?

924


Does google have a database program?

1077


How to pump the data from one database to another?

971


What is primary key in database?

961


What are the package used in DBMS ?

2672


Why is the use of dbms recommended?

1319


What is the purpose of database management system?

1105