Hi All,
I have a requirement that I have following data in my table
ID LocationID StateID
1 101 1001
2 102 1001
3 103 1001
4 104 1002
5 105 1002
I want to sql query which can return following result
Locations -- StateID
101,102,103 -- 1001
104,105 -- 1002