NickName:S.Shurane Ask DateTime:2016-10-29T15:34:35 How to convert this Microsoft SQL query into a MySQL query? 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 don't know how to do that. 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 Copyright Notice:Content Author:「S.Shurane」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.Link to original article:https://stackoverflow.com/questions/40317043/how-to-convert-this-microsoft-sql-query-into-a-mysql-query Answers