category

SQL

1 entries in this category
Parent: Coding
Siblings: *NIX:2, ASP:3, bookmarklets:1, Javascript / DHTML:2, Microsoft / Windows:1, OS X:2, PHP:2, Testing:2
Children: None

In this category


The Joys of COUNT

10th May 2006 11:50 | Comments Off
Categories: SQL, HowTo

COUNT has actually two forms: COUNT(*) counts the number of rows in a table; and COUNT(expr) counts the non-null occurrences of expr. This is very useful for generating reports, e.g.:

SELECT COUNT(*) AS 'Total', COUNT(ID_winner) AS 'Claimed'

this is what fritz looks like

Email | Resume

For ease of navigation, posts are classified in categories - this page shows all the posts within one of them.

'Child' lists all the sub-catgories, 'parent' shows the category of which the current one is a child, and siblings are categories which shares the same parent as this one.

RSS

ampersand

Fritz is an Italian chap who's been living in London and working in the digital industry for almost 20 years. He's currently freelancing as technical lead, developer, technical architect, information architect, and producer.

In the past he's been technical director for an integrated digital agency, a chef, and author of comics.