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 are codd rules?
Write a query to remove duplicate rows from a table?
Explain the advantages and disadvantages of a hierarchical database?
How to configure events with firewall?
What is normalisation and its type?
Name two utilities that oracle provides, which are use for backup and recovery.
Compare non-clustered and clustered index
What are vdl and sdl?
What are new features postgre 9.1?
What is database url?
What is implicit cursor in dbms?
What are the features of rdbms?
What is the database approach?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What do you understand by the view and mention the steps to create, update and drop a view?