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 the difference between hashed file stage and sequential file stage in relates to datastage server?
How do you set a primary key?
What is procedure in dbms?
What are cursors give different types of cursors?
What are the three levels of data abstraction?
Can you drop all the columns of a table ?
What is database example?
What is a clause in terms of sql?
Do models have limitations?
How do you performance tune a database?
What are the integrity rules in dbms?
What is normal form in dbms?
How do you handle your own transaction?
Is google scholar a database?
How is rdbms different from dbms?
