摘要：select * from(select no = row_number() over(partition by Gender order by getdate()),* from Student) twhere no=1 row_number()和rownum差不多，功能更强一点（可以在各个分组内 阅读全文