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 is a candidate key in dbms?

1080


Enlist the disadvantages of query.

1163


What are the six database objects?

919


Enlist ways to efficiently code transactions.

1120


How to configure events with firewall?

1049


Mention a query to calculate the even and odd records from a table

965


What is 2-tier architecture?

949


What is a string in database?

963


What is database normalization? Explain types of it.

999


What is meant by system analysis?

1088


What is string in database?

883


Do models have limitations?

898


What is in a database?

876


Explain data independence?

1043


What is the largest component of a database?

1302