For AVG , the non- NULL fields are summed and the sum divided by the number of non- NULL fields. ... so answer is 7.5
How many rows will the following SQL return :
Select * from emp Where rownum = 10;
Select * from emp Where rownum < 10;
which of the following is better to find the number of rows in a table? 1. count(1) 2. count(*) 3. count(rowid)