7.2 Additional SQL Functions
In addition to aggregate functions, SQL has several single-row functions, as well as statistical, analytical, date/time, and other types of functions.
Single-row functions are most often used in SELECT statements, where they can appear in the list following the SELECT clause, in the WHERE clause, or in the HAVING clause. Unlike aggregate functions, which operate on columns, single-row functions return one row for each row of the table or view on which they operate. The following examples use Oracle syntax to illustrate the use of these functions.
7.2.1 Numeric Single-Row Functions
Numeric functions are performed on numeric types, and they return numeric data. To illustrate some of these functions, let us assume ...
Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
