SELECT * FROM tablo GROUP BY urunid ORDER BY id DESC
gibi kullanabilirsiniz