SQL – Aggregate Functions In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. SQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the SQL aggregate functions […]
Category Archives: sql
SQL – Numeric Functions SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions − Sr.No. Function & Description 1 Returns the absolute value of numeric expression. 2 Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to […]
SQL – Stored Procedures Table of content SQL Stored Procedures An SQL stored procedure is a group of pre-compiled SQL statements (prepared SQL code) that can be reused by simply calling it whenever needed. It can be used to perform a wide range of database operations such as inserting, updating, or deleting data, generating reports, […]