top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: A table has the following data : [5, Null, 10]. What will the average function return?

+1 vote
587 views
Oracle: A table has the following data : [5, Null, 10]. What will the average function return?
posted Jan 2, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

For AVG , the non- NULL fields are summed and the sum divided by the number of non- NULL fields. ...
so answer is 7.5

answer Jan 2, 2015 by Devendra Kumar Maury
Similar Questions
+1 vote

How many rows will the following SQL return :

  Select * from emp Where rownum = 10;
+1 vote

How many rows will the following SQL return :

Select * from emp Where rownum < 10;
+1 vote

which of the following is better to find the number of rows in a table?
1. count(1)
2. count(*)
3. count(rowid)

...