i used this query to get particular result from a Microsoft sql server table. but now i need to convert this query into mySql query. i dont know how to do that. please help me.
SELECT TOP 3 COUNT(Item1) AS ITEM_COUNT,Item1
WHERE [Type] = 'Adidas' and [Age]='25'
GROUP BY Item1
ORDER BY ITEM_COUNT DESC
SELECT COUNT(Item1) AS ITEM_COUNT,Item1 FROM Suggetion_DB WHERE Type = 'Adidas' and Age='25' GROUP BY Item1 ORDER BY ITEM_COUNT DESC limit 3