Sorting data and Other selection Techniques

10/26/1999


Click here to start


Table of Contents

Sorting data and Other selection Techniques

Ordering data results

ORDER BY clause

Nested Ordering

Sort order

Ordering Expressions

Eliminating Duplicates

Non-select list Order By

Aggregate Functions

Syntax

Grouping data

GROUP BY clause

Syntax

Limitations

Grouping and Nulls

HAVING clause

Formatting Text

 Author: John T. Laker

Email: jlaker@udel.edu

Home Page: http://www.udel.edu/jlaker/sql99f/

Download presentation source