如何在SQL Server 2008中获取每个组的第一条记录和最后一条记录？

如何在SQL Server 2008中获取每个组的第一条记录和最后一条记录？

如何使用

ROW_NUMBER

：

SQL小提琴

WITH Cte AS(    SELECt *,        RnAsc = ROW_NUMBER() OVER(PARTITION BY [group] ORDER BY val),        RnDesc = ROW_NUMBER() OVER(PARTITION BY [group] ORDER BY val DESC)    FROM tbl)SELECt    id, [group], val, start, [end]FROM CteWHERe    RnAsc = 1 OR RnDesc = 1ORDER BY [group], val