how to count group by in sql server

Devendra Kumar

10y838

i have a query

in this query:

i want to count each shape have many products---------

SELECT tbl_shape.Shape,tbl_Image_Master.TagName, tbl_Image_Master.ProCode, tbl_shape.ShapeId, tbl_Image_Master.Shape_Id

FROM tbl_shape INNER JOIN tbl_Image_Master ON tbl_shape.ShapeId = tbl_Image_Master.Shape_Id

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

select     count(*) RecordsPerGroup,

 COUNT(*) OVER () AS TotalRecords from temptable

 group by column_1, column_2, column_3, column_4