2020-03-24
mysql查询
SELECT * FROM user WHERE id IN (SELECT * FROM authentication_infos WHERE audit_state=99 ORDER BY gmt_modify DESC LIMIT 10);
收藏
分享
2条回答
默认
最新
类似如下：
select * from user where user_id in(select user_id from cs_know where type=1 order by created_time desc limit 10);
评论
有用 0回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
墨值悬赏