• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

krisdb on 08/08/07

Tagged

sql

Versions (?)

08/08/07 06:40am

 / Published in: SQL

 

SELECT CASE WHEN (GROUPING(FIELD)=1) THEN 'Total' ELSE FIELD END AS FieldName
	,COUNT(id) AS Count
	FROM dbo.[TABLE]
	GROUP BY FIELD WITH ROLLUP

Report this snippet   Tweet