SQL Fundamentals, Third Edition

Chapter 9. Row Functions

In all the select statements we have written so far, the data in the result was an exact copy of the data in some cell of the beginning table. In this chapter, we remove that limitation. Row functions can create new values that do not exist in the original table.

Introduction to Row Functions		323
9-1	Getting data directly from the beginning table	323
9-2	What is a row function?	324
9-3	An example of a row function in the select clause	327
9-4	An example of a row function used in all the clauses of a select statement	329
9-5	Defining a row function as the first step	331
Numeric Functions		334
9-6	Functions on numbers	334
9-7	How to test a row function	336
9-8	Another way to test a numeric row function	337
Text Functions		340
9-9	Functions on text	340
9-10 ...