Hp Intelligent Management Center Standard Software Pl Manual de usuario descargar pdf (Pagina 703)

100

101

ORDER BY

The ORDER BY clause specifies that the database records retrieved be

sorted according to the values in a specific field. If you do not use the ORDER

BY clause, the program retrieves records in the order in which they appear

in the original database. If you specify more than one field after the ORDER

BY clause, the program sorts the records according to the values in the first

field specified, then, within that sort, the program sorts the records by the

values in the second field specified, and so on. The following SQL statement

uses the ORDER BY clause:

SELECT

MYTABLE.'COMPANY',

MYTABLE.'CITY',

MYTABLE.'STATE'

FROM

'MYTABLE' MYTABLE

ORDER BY

MYTABLE.'STATE' ASC,

MYTABLE.'CITY' ASC

Note:

ASC indicates that the values in the field are sorted in ascending order rather

than descending order (DESC). Ascending order sorts letters from A to Z

and numbers from 0 to 9.

GROUP BY

The GROUP BY clause retrieves a set of summary data. Instead of retrieving

the data itself, GROUP BY groups the data and summarizes each group with

an SQL aggregate function. The server returns only the summarization

information for each group to Crystal Reports.

For example:

SELECT

MYTABLE.'STATE',

MYTABLE.'ZIPCODE',

SUM (MYTABLE.'SALES')

FROM

'MYTABLE' MYTABLE

GROUP BY

Crystal Reports 2008 SP3 User's Guide 703

Understanding Databases

Using SQL and SQL databases

1 2 ... 698 699 700 701 702 703 704 705 706 707 708 ... 813 814

Comentarios a estos manuales

Sin comentarios

Hp Intelligent Management Center Standard Software Pl Manual de usuario Pagina 703

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Intelligent Management Center Standard Software Pl