Create is not an aggregate function- Database

Q.  Database: Which is not a function of aggregate function?
- Published on 29 Jun 15

a. Count
b. Avg
c. Create
d. Max

ANSWER: Create
 
The aggregate functions are used for calculation in the database. The create is a keyword used in dbms.
 

    Discussion

  • Nirja Shah   -Posted on 05 Nov 15
    - Aggregate functions return a single value, calculated from values in a column.

    - Some of the useful aggregate functions:

    - AVG() - It returns the average value
    - COUNT() - It returns the number of rows
    - FIRST() - It returns the first value
    - LAST() - It returns the last value
    - MAX() - It returns the largest value
    - MIN() - It returns the smallest value
    - SUM() - It returns the sum

    - CREATE is a DDL statement which is used to create objects,functions,tables in the database

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)