COUNT(*) (was RE: [thelist] SQL query to create aging buckets)

Joel D Canfield joel at spinhead.com
Wed Dec 17 16:23:14 CST 2003


> SELECT datediff(d,duedate,getdate()), Count(*) AS TheCount 

	> How does 'Count(*)' know what it's counting? What is the
wildcard 
	matching? BOL isn't offering an answer 
	

	

	Answering my own question: Books On Line *does* cover it, if you
look harder: COUNT aggregate function | Using COUNT(*)



More information about the thelist mailing list