SELECT *,(SELECT count(*) FROM analysis_talent_policy WHERE policy_level='深圳') AS totel FROM analysis_talent_policy WHERE policy_level='深圳' ORDER BY id LIMIT 6,6
一条sql查寻结果数量和分页查询(子查询方法实现)
最新推荐文章于 2021-05-18 23:08:11 发布
SELECT *,(SELECT count(*) FROM analysis_talent_policy WHERE policy_level='深圳') AS totel FROM analysis_talent_policy WHERE policy_level='深圳' ORDER BY id LIMIT 6,6