这条SQL怎么写?

Question

一个学生表ID,name,sex
用一条sql查询5个男生和5个女生,安ID排序

Answer 1

表student
[code="java"]
select * from student as s where s.ID in (select s1.ID from student as s1 where s1.sex='男' order by s1.ID asc limit 5 offset 0 ) or s.ID in (select s2.ID from student as s2 where s2.sex='女' order by s2.ID asc limit 5 offset 0 )
[/code]

你看下行不……
SQL语句我不会优化 :oops: