SELECT url, MAX(CONVERT(字段名,SIGNED))
FROM 热搜
GROUP BY url
HAVING MAX(CONVERT(字段名,SIGNED)) > 1000
涉及字符串转整数函数
CONVERT(字段名,SIGNED)
SELECT url, MAX(CONVERT(字段名,SIGNED))
FROM 热搜
GROUP BY url
HAVING MAX(CONVERT(字段名,SIGNED)) > 1000
涉及字符串转整数函数
CONVERT(字段名,SIGNED)