Answer Posted / naresh
select avg(sal) from emp group by deptno;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the role of tables in database?
Which two statements are true about a foreign key?
Which database is best for storing large data?
How to configure events with firewall?
What is a database in a website?
Explain 2nf?
How many database systems are there?
What is database partitioning?
What is database transaction?
What do you mean by query evaluation engine?
How to change database dialect?
When we will denormalize data?
How do I add a file to a database?
What is structure of dbms?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
