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.