一个比较难的sql语句，大家帮忙看一下

Question

1    XS01040615100012 2004-05-28 00:00:00.000 2004-06-15 00:00:00.000
2    XS01040616080001 2003-08-17 00:00:00.000 2004-06-16 00:00:00.000
3    XS01040616080002 2004-01-11 00:00:00.000 2004-06-16 00:00:00.000
4    XS01040616080003 2004-06-10 00:00:00.000 2004-06-16 00:00:00.000
5    XS01040616080004 2004-05-30 00:00:00.000 2004-06-16 00:00:00.000
6    XS01040616080005 2004-04-06 00:00:00.000 2004-06-16 00:00:00.000
7    XS01040616080006 2004-06-12 00:00:00.000 2004-06-16 00:00:00.000
8    XS01040616080007 2004-06-03 00:00:00.000 2004-06-16 00:00:00.000
9    XS01040616080008 2004-02-15 00:00:00.000 2004-06-16 00:00:00.000
10    XS01040616080009 2004-04-03 00:00:00.000 2004-06-16 00:00:00.000
11    XS01040616080010 2004-05-01 00:00:00.000 2004-06-16 00:00:00.000
12    XS01040616080011 2004-03-31 00:00:00.000 2004-06-16 00:00:00.000
13    XS01040616080012 2004-02-12 00:00:00.000 2004-06-16 00:00:00.000
14    XS01040616080013 2004-02-22 00:00:00.000 2004-06-16 00:00:00.000
15    XS01040616080014 2004-02-23 00:00:00.000 2004-06-16 00:00:00.000
16    XS01040616080015 2004-04-24 00:00:00.000 2004-06-16 00:00:00.000
17    XS01040616080016 2004-03-25 00:00:00.000 2004-06-16 00:00:00.000
18    XS01040616080017 2004-02-07 00:00:00.000 2004-06-16 00:00:00.000
19    XS01040616080018 2003-12-21 00:00:00.000 2004-06-16 00:00:00.000
20    XS01040617100001 2003-08-17 00:00:00.000 2004-06-17 00:00:00.000

Answer 1

select ID2,Time1
from 表 
where ID2 is not null and datediff(dd,Time1,Time2)<0
group by ID2,Time1