select * from tool_zgjm where `type`=1 limit 10;
select * from tool_zgjm where `type`=2 limit 10;
select * from tool_zgjm where `type`=3 limit 10;
select * from tool_zgjm where `type`=4 limit 10;
select * from tool_zgjm where `type`=5 limit 10;
select * from tool_zgjm where `type`=6 limit 10;
一条sql搞定
正好以前见朋友聊过,答案如下
SELECT *
FROM tool_zgjm a1
WHERE 10 >
(
SELECT COUNT(*)
FROM tool_zgjm a2
WHERE a2.type = a1.type
AND a2.id>a1.id
)
#取大值
SELECT *
FROM t_test a1
WHERE 3 >
(
SELECT COUNT(*)
FROM t_test a2
WHERE a2.test = a1.test
AND a2.Id<a1.Id
)
#取小值
mysql 推荐表 操作
最新推荐文章于 2021-01-19 07:34:05 发布