Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Name - Priyanshu Gupta Sec-4E ISM AssignmentNo-4.4

    Uploaded by

    himani7sharma2
    ISM ASSIGNMENT

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Name - Priyanshu Gupta Sec-4E ISM AssignmentNo-4.4

    Uploaded by

    himani7sharma2
    8 views2 pages
    ISM ASSIGNMENT

    Original Title

    Name- Priyanshu Gupta Sec-4E ISM AssignmentNo-4.4

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    ISM ASSIGNMENT

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    8 views2 pages

    Name - Priyanshu Gupta Sec-4E ISM AssignmentNo-4.4

    Uploaded by

    himani7sharma2
    ISM ASSIGNMENT

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Assignment-4.

    Q.1 Explain all aggregate functions with the help of an example

    Ans 1. Aggregate functions in DBMS take multiple rows from the table and return a value
    according to the query.
    All the aggregate functions are used in Select statement.
    Syntax −
    SELECT <FUNCTION NAME> (<PARAMETER>) FROM <TABLE NAME>
    AVG Function
    This function returns the average value of the numeric column that is supplied as a
    parameter.
    Example: Write a query to select average salary from employee table.
    Select AVG(salary) from Employee

    COUNT Function
    The count function returns the number of rows in the result. It does not count the null
    values.
    Example: Write a query to return number of rows where salary > 20000.
    Select COUNT(*) from Employee where Salary > 20000;
    Types −
     COUNT(*): Counts all the number of rows of the table including null.
     COUNT( COLUMN_NAME): count number of non-null values in column.
     COUNT( DISTINCT COLUMN_NAME): count number of distinct values in a
    column.

    MAX Function
    The MAX function is used to find maximum value in the column that is supplied as a
    parameter. It can be used on any type of data.
    Example − Write a query to find the maximum salary in employee table.
    Select MAX(salary) from Employee
    SUM Function
    This function sums up the values in the column supplied as a parameter.
    Example: Write a query to get the total salary of employees.
    Select SUM(salary) from Employee

    You might also like