You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by legolas wood <le...@gmail.com> on 2006/12/16 14:43:22 UTC

what is different between count(*) and count(field_name) ?

Hi
Thank you for reading my post
what is different between count(*) and count(field_name) ?
thanks

Re: what is different between count(*) and count(field_name) ?

Posted by Barry Books <tr...@gmail.com>.

count(*) wil return the count of all rows

count(field) will return count where field is not null