在sqlserver中,分组查询后只取每组的第一条数据
select A.*
from (
select ObjId,RowNo,OwnerObjId,ROW_NUMBER() OVER(PARTITION BY RowNo order by RowNo) as Row_Sort
from Student
where OwnerObjId='b341d83f6bf0467187e2d0514856136a'
)as A
where A.Row_Sort=1 AND OwnerObjId='b341d83f6bf0467187e2d0514856136a' order by A.RowNo;