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

Joel D Canfield joel at
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
	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