O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

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

Chapter 4Retrieving Records

Introduction

A database is only useful if you can get records out of it. While there are many ways to get data from the database, the place to begin is the SELECT statement, which is the key to retrieving records. Then we will build on this statement to concatenate columns and create alternate names for columns. Finally, we will show how to get subsets of the database and sort the output.

Keywords

AS

ASC

DESC

DISTINCT

DISTINCTROW

ORDER BY

SELECT

TOP

TOP PERCENT

Definitions

Alias — An alternate name for a table or column.

AS — Used to assign an alternate name to a column or table.

ASC — Used to sort column values in ascending order.

Clause — A segment of an SQL statement that assists in the selection and manipulation ...

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