我想使用mysql获取10条记录,其中5条记录的性别=男性和5条记录的性别=女性与id DESC。
我需要两个单独的查询吗?
SELECT * FROM `users` where gender='male' ORDER BY id DESC LIMIT 5
SELECT * FROM `users` where gender='female' ORDER BY id DESC LIMIT 5
SELECT * FROM `users` where gender='male' ORDER BY id DESC LIMIT 5
union
SELECT * FROM `users` where gender='female' ORDER BY id DESC LIMIT 5
将返回5个按ID排序的男性用户和5个按ID排序的女性用户,结果总共有10条记录。
这就是你想要的吗?