Re: Number of rows in a table

Am Mo, 2003-08-25 um 18.14 schrieb Tomka Gergely:
> 2003-08-25 ragyogó napján Louise Cofield ezt üzente:
>
> > I haven't been able to figure out how to determine the number of
> > populated rows in a table - such as "select max(rownum)" in Oracle.
>
> select count(*) from usw.; ?

Keep i mind Louise, that this is an aggregate function, i.e. all other
columns you want to get in the same query must be GROUPed or used in an
aggregate function, too.

bye
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de