Devendra  Kumar

Devendra Kumar

  • NA
  • 517
  • 246k

how to count group by in sql server

Mar 7 2016 11:48 PM
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
 

Answers (1)