Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595