巧用MIN ,MAX ,函数
假如有这样个数据:
ID TIME
1 23:12
1 12:34
1 21:34
2 12:56
2 08:23
-----------------------------
ID FIRST LAST
1 12:34 23:12
2 08:23 12:56
SELECT ID,MIN(TIME) AS FIRST,MAX(TIME) AS LAST FROM ?? GROUP BY ID
假如有这样个数据:
ID TIME
1 23:12
1 12:34
1 21:34
2 12:56
2 08:23
-----------------------------
ID FIRST LAST
1 12:34 23:12
2 08:23 12:56
SELECT ID,MIN(TIME) AS FIRST,MAX(TIME) AS LAST FROM ?? GROUP BY ID