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 […]
Author Archives: user
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 […]
SQL – String Functions SQL string functions are used primarily for string manipulation. The following table details the important string functions − Sr.No. Function & Description 1 Returns numeric value of left-most character 2 Returns the character for each integer passed 3 Returns the position of a substring within the given string. 4 Returns concatenate […]