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

Dept wise avrage salary

Question Posted / suraj

Answer Posted / suraj

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the main difference between union and union all?

832

Explain the different types of constraints in dbms?

950

What are the uses of database management system?

931

What is database url?

897

Why would someone use a database?

872

What is the default '-sort' order for a sql?

839

Is google a database?

1097

What is a data source (ds)?

875

What is record in a database?

807

Can we save file in database?

851

What are the limitations of rdbms?

897

Mention few case manipulation functions in sql

920

How many number of columns can a RECORD GROUP have ?

1971

What is a 3nf table?

832

What is alternate key?

849