Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 GROUP BY?

Author  Topic 

nubliss81
Starting Member

1 Post

Posted - 2006-11-13 : 16:34:35
Need to select data and group it by a specified column, then display a total amount of grouped items at the end of each group, then display a grand total of all grouped totals. Help? Let me know if you need additional info.

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-13 : 16:40:44
SELECT Col1, COUNT(*) FROM myTable99 GROUP BY Col1 WITH ROLLUP

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -