An SQL primer

adsm> select count(*) from syscat.enumtypes

Unnamed[1]

-----------

9

adsm> select count(*) as "Number of Rows" from syscat.enumtypes

Number of Rows

--------------

9

adsm> select sum(valuecount) as "Sum of valuecount" from syscat.enumtypes

Sum of valuecount

-----------------

25

Vorherige Folie

Nächste Folie

Zurück zur ersten Folie

Graphik-Version anzeigen