S.Shurane S.Shurane - 1 month ago 11
MySQL Question

I need convert this Microsoft SQL query into MySql query.. Please help me

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
FROM [cloths_DB].[dbo].[Suggetion_DB]
WHERE [Type] = 'Adidas' and [Age]='25'
GROUP BY Item1
ORDER BY ITEM_COUNT DESC

Answer
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