veenaIPnotes

  SQL   is a unified, non-procedural language used for creating, accessing, handling and mnaging data in relational databases. FUNCTIONS IN SQL A function can be defined as a pre-defined set of commands that helps in performing certain operations to obtain either a single value or a result set. SQL provides a large collection of in-built functions, also called library functions, that can be used directly with SQL statementsfor performing calculations on data. The functions used in SQL can be categorised into two categories namely single row or scalar functions and multiple row or group or aggregate functions. SINGLE ROW  FUNCTIONS: Single Row Functions operate  on a single row or single value to return one value per row as the outout. they can accept one or more arguments but return only one result per row. These are  also known as Scalar Functions.   They can be used with SELECT,  WHERE and ORDER by clause. Numeric Functions: ROUND () : syntax: S...