sql 重复数据中读取不同的前面几条
如何快速读取前面几条记录：
取得结果如下图：
或者结果如下图：
[最优解释]
select * from (select *,rowindex=row_number()over(partition by name order by id) from 表)t where t.rowindex<=5
[其他解释]
select distinct(name),hospitalid,hospitalname from hospital group by name,hospitalid,hospitalname
