ID | Value | Date |
---|---|---|
1 | 10 | 2023-10-12 16:10:59.457 |
1 | 20 | 2023-10-12 14:20:54.997 |
1 | 30 | 2023-10-13 10:30:59.457 |
1 | 70 | 2023-10-13 10:20:54.997 |
2 | 10 | 2023-10-12 18:00:59.457 |
2 | 20 | 2023-10-13 14:00:54.997 |
我有一个带有和ID、一些值和一个日期字段的表,我想按ID和日期分组,但只取每个ID的最大日期值.我的数据库是SQL Server.
ID | Value | Date |
---|---|---|
1 | 10 | 2023-10-12 16:10:59.457 |
1 | 30 | 2023-10-13 10:30:59.457 |
2 | 10 | 2023-10-12 18:00:59.457 |
2 | 20 | 2023-10-13 14:00:54.997 |