Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which of the following is a SQL aggregate function?

  2. A.

     LEFT

    B.

     AVG

    C.

     JOIN

    D.

     LEN

    View Answer

    Workspace

    Answer : Option B

    Explanation :

    SQL has several arithmetic functions to do math on the numbers, such as summing up, taking average, retrieved from the column. They are:
    AVG():- Average of the column
    COUNT():- Number of records
    MAX():- maximum of the column
    MIN():- minimum of the column
    SUM():- Sum of the column


Be The First To Comment