Question

用sql语句实现按条件随机取几条记录

现在A表里有一列班级，一列学生姓名，怎么用sql语句实现每个班级随机找出10名学生的结果。谢谢大家了

Answer 1

select * from A where 姓名 in (select 10 姓名 from A where 班级=A班级 order by newid()) order by 班级
其中newid()会随机从班级里查找10名学生！

Answer 2

楼主应该指明用的何种数据库，
oracle可以用下面的方式
select * from (select * from tablename order by dbms_random.value) where rownum<10

mysql：
SELECT * FROM table ORDER BY rand() LIMIT 10;

Answer 3

select * from A where 姓名 in (select top 10 姓名 from A where 班级=A.班级)
order by 班级

Answer 4

select *
from (
select *,rn=row_number()OVER(PARTITION BY 班级 order by newid())
from A) k
where rn<=10;