Hi naidu.6180,
Please share current output and expected output with some dummy record.
Or check with the below sample query.
DECLARE @Table_Name AS TABLE
(
ID INT IDENTITY
,Location VARCHAR(20)
,Image VARCHAR(20)
,Title VARCHAR(20)
,IsValid BIT
)
INSERT INTO @Table_Name VALUES('Location 1','Image 1','Title 1',1)
INSERT INTO @Table_Name VALUES('Location 1','Image 1','Title 2',1)
INSERT INTO @Table_Name VALUES('Location 3','Image 3','Title 3',1)
INSERT INTO @Table_Name VALUES('Location 4','Image 4','Title 4',0)
INSERT INTO @Table_Name VALUES('Location 5','Image 5','Title 5',1)
INSERT INTO @Table_Name VALUES('Location 6','Image 6','Title 6',0)
INSERT INTO @Table_Name VALUES('Location 7','Image 7','Title 7',0)
SELECT Location,Image,Count(ID) Total
FROM @Table_Name
WHERE IsValid = 1
GROUP BY Location,Image
Output
Location |
Image |
Total |
Location 1 |
Image 1 |
2 |
Location 3 |
Image 3 |
1 |
Location 5 |
Image 5 |
1 |