SQL – Text & Image functions SQL Text and Image functions operate on text and image data. The text and image functions are − Sr.No. Function & Description 1 Returns the pointer value of the text or images. 2 Returns an integer value(1 for valid, 0 for non-valid). Khóa học lập trình tại Toidayhoc vừa […]

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 – 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 […]