Sqlserver查询每组数据中最大的一条数据

select * from (
SELECT  ROW_NUMBER()   
        over   
        (PARTITION By name order by val) as rowId,tb_test.*
FROM tb_test 
) t
where rowid <= 1