Alexander Gattin <xr...@yandex.ru> writes: >> The proper way to get the number of rows is to >> use the COUNT aggregate function, e.g., "SELECT >> COUNT(*) FROM TABLE1", which will return a >> single row with a single column containing the >> number of rows in table1. > > It's better to select count(1) instead of > count(*). The latter may skip rows consisting > entirely of NULLs IIRC.
Wrong: count(anyname) ignores NULL, whereas count(*) does not. -- Alain. -- http://mail.python.org/mailman/listinfo/python-list