GROUP BY Clause

View All Public Scripts Login to Run Script

Script Name GROUP BY Clause
Visibility Unlisted - anyone with the share link can access
Description The GROUP BY statement groups rows that have the same values into summary rows, like "find the number of customers in each country". The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns. CREATED BY- EKTA NARWAL
Area SQL Types
Contributor ekta_narwal@yahoo.com
Created Sunday May 17, 2020

Statement 1

CREATE TABLE employee(eid number(4), ename char(15), ework varchar(12))

Table created.

Statement 2

INSERT INTO employee VALUES(893, 'Ritu', 'Accountant')

1 row(s) inserted.

Statement 3

INSERT INTO employee VALUES(1896, 'Parv', 'Banker')

1 row(s) inserted.

Statement 4

INSERT INTO employee VALUES(6725, 'Seema', 'Clerical')

1 row(s) inserted.

Statement 5

INSERT INTO employee VALUES(672, 'Seema', 'Clerical')

1 row(s) inserted.

Statement 6

INSERT INTO employee VALUES(1896, 'Parvesh', 'Banker')

1 row(s) inserted.

Statement 7

select * from employee


EID ENAME EWORK
893 Ritu           Accountant
1896 Parv           Banker
6725 Seema          Clerical
672 Seema          Clerical
1896 Parvesh        Banker

5 rows selected.

EID	ENAME	EWORK
893	Ritu	Accountant
1896	Parv	Banker
6725	Seema	Clerical
672	Seema	Clerical
1896	Parvesh	Banker

Statement 8

select SUM (eid) from employee where ework= 'Clerical' order by ename


SUM(EID)
7397

SUM(EID)
7397

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database