摘要:
select count(*),t1.`name` from test_id t1INNER JOIN test_id t2on t1.id >= t2.idgroup by t1.id,t1.`name`HAVING count(*) < t1.idorder by t1.idlimit 1;se... 阅读全文
posted @ 2014-12-16 12:46 懒人ABC 阅读(503) 评论(0) 推荐(0) 编辑
摘要:
select count(*),t1.`name` from test_id t1INNER JOIN test_id t2on t1.id >= t2.idgroup by t1.id,t1.`name`HAVING count(*) < t1.idorder by t1.idlimit 1;se... 阅读全文
posted @ 2014-12-16 12:46 懒人ABC 阅读(503) 评论(0) 推荐(0) 编辑 |
||