Results 1 to 3 of 3

Aggregate Functions are available there in SQL ?

This is a discussion on Aggregate Functions are available there in SQL ? within the Programming forums, part of the Web Designing & Development category; Hello Dear, Please Tell Me How many Aggregate Functions are available there in SQL ?...

  1. #1
    Senior Member
    Join Date
    Apr 2015
    Posts
    206

    Default Aggregate Functions are available there in SQL ?

    Hello Dear,

    Please Tell Me How many Aggregate Functions are available there in SQL ?

  2. #2
    Senior Member
    Join Date
    Jan 2018
    Location
    PUNE
    Posts
    281

    Default Re: Aggregate Functions are available there in SQL ?

    5



    Summary. MySQL supports all the five (5) ISO standard aggregate functionsCOUNT, SUM, AVG, MIN and MAX. SUM and AVG functions only work on numeric data. If you want to exclude duplicate values from the aggregate function results, use the DISTINCT keyword.

  3. #3
    Senior Member
    Join Date
    Jan 2018
    Location
    PUNE
    Posts
    281

    Default Re: Aggregate Functions are available there in SQL ?

    The DROP command removes a table from the database. ... DROP and TRUNCATEare DDL commands, whereas DELETE is a DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back