O'Reilly logo

Practical SQL Handbook, The: Using SQL Variants, Fourth Edition by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C. Glossary

access strategy

The method by which a database management system locates physical data.

aggregate functions

Often used with the GROUP BY and HAVING clauses, aggregate functions generate one summary value from a group of values in a specified column. Aggregate functions include AVG, SUM COUNT, COUNT(*), MIN, and MAX.

alias

A temporary name given to a table (in the FROM clause). Here are two examples of how it can be used:

select au_id, a.city, p.city, pub_id
from authors a, publishers p
where au_lname like 'P%'

select a.au_id, b.au_id
from authors a, authors b
where a.zip = b.zip

In the first example, the alias eliminates the need to type the whole table name as a qualifier for each column name that could belong to either table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required