Chapter No-16-XII

							CHAPTER NO-16


Grouping Records
and Table joins
TYPES OF SQL FUNCTIONS

Single Row (Scalar )function:-
Those functions that work with a
single row at a time. It return a
result for every row of a table

Examples: Year(),Day,Char()..
Multiple Row (Group)function:-
Those functions that work with
data of multiple row at a time. It
return aggregated value.

Examples:SUM(),COUNT(),MIN(),M
AX()
EX:- SELECT JOB,COUNT(*) FROM EMPL GROUP
BY JOB;
PLACING CONDITIONS ON
GROUPS-HAVING CLAUSE
The Having clause is used to specify
filtering condition for group.

The difference between WHERE and
HAVING clause is that where condition
are applicable on individual rows
whereas having condition are applicable
on group as formed by group by clause.