Hi naidu.6180,
Refer below sample query.
DECLARE @Locationinfo AS TABLE
(
Id Int Primary key Identity(1,1)
,Name nvarchar(50) Not Null
,Location Nvarchar(50) Not Null
,Image nvarchar(50) not Null
)
INSERT INTO @Locationinfo VALUES('Naidu','Bangalore','naidu.JPG')
INSERT INTO @Locationinfo VALUES('Raju','Mumbai','Some.JPG')
INSERT INTO @Locationinfo VALUES('Naidu','Bangalore','naidu.JPG')
INSERT INTO @Locationinfo VALUES('Babu','HYD ','Some.jpg')
INSERT INTO @Locationinfo VALUES('Raju','Mumbai','Some.JPG')
INSERT INTO @Locationinfo VALUES('Raju','Mumbai','Some.JPG')
INSERT INTO @Locationinfo VALUES('Babu','HYD','Some.jpg')
INSERT INTO @Locationinfo VALUES('Raju','Mumbai','Some.JPG')
INSERT INTO @Locationinfo VALUES('Raju','Mumbai','Some.JPG')
SELECT Count(Id) AS 'Count(ID)',Location,Name,Image
FROM @Locationinfo
GROUP BY Location,Name,Image
ORDER BY Image,Name DESC,Location
Output
| Count(ID) |
Location |
Name |
Image |
| 2 |
Bangalore |
Naidu |
naidu.JPG |
| 5 |
Mumbai |
Raju |
Some.JPG |
| 2 |
HYD |
Babu |
Some.jpg |
