Query that returns grouped data

[tabreaz]

Try this query it should be helpful

SELECT * FROM STORES
WHERE ROWID IN
(
	SELECT MAX(ROWID) OVER(PARTITION BY STORE, CATEGORY)
	FROM STORES
)