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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
