View Single Post
  #4 (permalink)  
Old Mar 18th, 2006, 07:25
Pheonix Pheonix is offline
Reputable Member
Join Date: Sep 2005
Location: Canada, BC
Age: 24
Posts: 239
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Counting Instances in a table.

Quote:
Originally Posted by grahame
Your solution is a good one, although I would count(ID) to count the number of non-NULL values in that particular column rather than counting all columns.
I don't understand what you mean. Just use the ID column instead of all columns? what purpose? to increase speed?
Reply With Quote