SQL GROUP BY CLOUSE

-------------------------------------------------------
CREATE TABLE GRP(EMPID NUMBER,ADDRESS VARCHAR(20),
AGE NUMBER,JOB VARCHAR(20));
INSERT INTO GRP VALUES(1,'DELHI',15,'IT');
INSERT INTO GRP VALUES(2,'BOMBAY',20,'IT');
INSERT INTO GRP VALUES(3,'DELHI',30,'ORACLE');
INSERT INTO GRP VALUES(4,'GOA',25,'IT');
INSERT INTO GRP VALUES(5,'DELHI',20,'TALLY');
INSERT INTO GRP VALUES(6,'BOMBAY',25,'ORACLE');
INSERT INTO GRP VALUES(7,'DELHI',30,'IT');
INSERT INTO GRP VALUES(8,'GOA',15,'TALLY');
INSERT INTO GRP VALUES(9,'BOMBAY',15,'IT');
INSERT INTO GRP VALUES(10,'DELHI',20,'TALLY');
INSERT INTO GRP VALUES(11,'DELHI',15,'ORACLE');
INSERT INTO GRP VALUES(12,'GOA',15,'IT');
INSERT INTO GRP VALUES(13,'DELHI',25,'IT');
INSERT INTO GRP VALUES(14,'GOA',30,'ORACLE');
INSERT INTO GRP VALUES(15,'DELHI',20,'TALLY');
COMMIT;


ALTER TABLE GRP
ADD(SALARY NUMBER);

UPDATE GRP
SET SALARY=15000;
SELECT * FROM GRP;
---------------------------------------------------

select address,count(*),sum(salary)
from grp
group by address;


select job,count(*),sum(salary)
from grp
group by job;


select age,count(*),sum(salary)
from grp
group by age;


---------------------------------------------------



select address,age,count(*),sum(salary)
from grp
group by address, age;


select job,address,age,count(*),sum(salary)
from grp
group by job,address, age;

----------------------------------------------------
select address,count(*),sum(salary)
from grp
group by address
having address='DELHI';
--------------------------------------------------------
SELECT ADDRESS, JOB,
AGE,SUM(salary),COUNT(EMPID)
FROM GRP
GROUP BY GROUPING SETS
((ADDRESS,job), (job,AGE));
---------------------------------
SELECT ADDRESS, joB,AGE,
SUM(salary)
FROM GRP
GROUP BY ROLLUP( ADDRESS,(job,AGE));
--------------------------

SELECT ADDRESS, joB,AGE,
SUM(salary)
FROM GRP
GROUP BY cube( ADDRESS,(job,AGE));

----------------------------------
SELECT ADDRESS,JOB,AGE,
SUM(salary)
FROM GRP
GROUP BY ADDRESS,
ROLLUP(JOB),
CUBE(AGE);
-----------------------------------
SELECT ADDRESS,JOB,AGE,
COUNT(JOB)
FROM GRP
GROUP BY ADDRESS,
ROLLUP(JOB),
CUBE(AGE);
---------------------------------
SELECT  EMPID, job,
SUM(salary),
GROUPING(EMPID) GRP_DEPT,
GROUPING(job) GRP_JOB
FROM employees
GROUP BY ROLLUP(EMPid, job);