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
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What are the properties of a database?
What is rdbms and its types?
What is tabular form?
What is database optimization?
What are the drawback of rdbms?
define aggregate functions.
Is a database a file?
What is dbms with example?
What is database host?
What is a distributed database?
What restrictions can you apply when you are creating views?
What are the ways to tune reporting services?
What do you understand by the view and mention the steps to create, update and drop a view?
Define sub-query.