Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    SQ L Group by Claushie

    Uploaded by

    yusuf
    The SQL GROUP BY clause is used to retrieve data grouped according to one or more columns. It is used along with group functions like SUM to aggregate data for each group. For example, to find the total salary spent in each department, a query would use GROUP BY with the department column and SUM on the salary column. The GROUP BY clause should contain all non-aggregate columns selected.

    Copyright:

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

    SQ L Group by Claushie

    Uploaded by

    yusuf
    35 views1 page
    The SQL GROUP BY clause is used to retrieve data grouped according to one or more columns. It is used along with group functions like SUM to aggregate data for each group. For example, to find the total salary spent in each department, a query would use GROUP BY with the department column and SUM on the salary column. The GROUP BY clause should contain all non-aggregate columns selected.

    Original Description:

    hhi

    Original Title

    Sq l Group by Claushie

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The SQL GROUP BY clause is used to retrieve data grouped according to one or more columns. It is used along with group functions like SUM to aggregate data for each group. For example, to find the total salary spent in each department, a query would use GROUP BY with the department column and SUM on the salary column. The GROUP BY clause should contain all non-aggregate columns selected.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    35 views1 page

    SQ L Group by Claushie

    Uploaded by

    yusuf
    The SQL GROUP BY clause is used to retrieve data grouped according to one or more columns. It is used along with group functions like SUM to aggregate data for each group. For example, to find the total salary spent in each department, a query would use GROUP BY with the department column and SUM on the salary column. The GROUP BY clause should contain all non-aggregate columns selected.

    Copyright:

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

    8/10/13

    SQL Group By Clause

    SQL GROUP BY Clause


    The SQL GROUP BY C lause is used along with the group functions to retrieve data grouped according to one or
    more columns.
    For Example: If you want to know the total amount of salary spent on each department, the query would be:

    SELECT dept, SUM (salary)


    FROM employee
    GROUP BY dept;
    The output would be like:

    dept
    salary
    ------------- --------------Electrical
    25000
    Electronics 55000
    Aeronautics 35000
    InfoTech
    30000
    NOTE: The group by clause should contain all the columns in the select list expect those used along with the
    group functions.

    SELECT location, dept, SUM (salary)


    FROM employee
    GROUP BY location, dept;
    The output would be like:

    location
    dept
    salary
    ------------ ------------- ----------Bangalore Electrical
    25000
    Bangalore Electronics 55000
    Mysore
    Aeronautics 35000
    Mangalore InfoTech
    30000

    beginner-sql-tutorial.com/sql-group-by-clause.htm

    1/1

    You might also like