Thread: SQL -select count-

when I do :

select count(column_name) from table_name

should I get the count for all columns or just those which are not null?
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com

On Tuesday 19 Nov 2002 5:06 pm, Giannis wrote:
> when I do :
>
> select count(column_name) from table_name
>
> should I get the count for all columns or just those which are not null?

Just "not null" - use count(*) or count(0) for a count of rows.

--  Richard Huxton

On Tue, 19 Nov 2002, Giannis wrote:

> when I do :
>
> select count(column_name) from table_name
>
> should I get the count for all columns or just those which are not null?

Γιάννη,
θα πάρεις το πλήθος των κολόνων !! που δεν είναι null.

Γιατι δεν κάνεις ένα τέστ μόνος?

> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr