SQL-Functions

nFunctions in SQL are classified into two types

ØAggregate Functions-SQL Aggregate functions return a single value, using values in a table column.

ØScalar Functions

    You use scalar functions to return information from a database. You can use them in a SELECT list, a WHERE clause, and anywhere an expression is allowed.