top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
107 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)

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...