distinct中第一条和最后一条

查找distinct中的第一条和最后一条

SELECT DISTINCT Z,FIRST_VALUE(TM) OVER (PARTITION BY Z ORDER BY TM) AS TM FROM Tablename order by TM;

最后一条用LAST_VALUE