SQL 数据处理问题
ID start end flag
A12013-01-23 13:22:27.6572013-01-23 13:23:04.0370*
A12013-01-23 13:23:04.0372013-01-23 14:16:41.8231*
A12013-01-23 14:16:41.8232013-01-23 14:17:01.3430
A12013-01-23 14:17:01.3432013-01-23 14:17:20.0500
A12013-01-23 14:17:20.0502013-01-23 14:17:41.4400
A12013-01-23 14:17:41.4402013-01-23 14:18:05.3100
A12013-01-23 14:18:05.3102013-01-23 14:19:17.8170
A12013-01-23 14:19:17.8172013-01-23 14:23:42.4470
A12013-01-23 14:23:42.4472013-01-23 14:24:05.3570
A12013-01-23 14:24:05.3572013-01-23 14:24:42.5130
A12013-01-23 14:24:42.5132013-01-23 14:25:22.5300
A12013-01-23 14:25:22.5302013-01-23 14:25:43.8000
A12013-01-23 14:25:43.8002013-01-23 14:26:10.5770
A12013-01-23 14:26:10.5772013-01-23 14:28:56.2970
A12013-01-23 14:28:56.2972013-01-23 14:31:27.7730
A12013-01-23 14:31:27.7732013-01-23 14:31:43.7700
A12013-01-23 14:31:43.7702013-01-23 14:36:19.9670
A12013-01-23 14:36:19.9672013-01-23 14:36:32.2330
A12013-01-23 14:36:32.2332013-01-23 14:36:40.6500
A12013-01-23 14:36:40.6502013-01-23 14:37:13.9670
A12013-01-23 14:37:13.9672013-01-23 14:38:47.4670
A12013-01-23 14:38:47.4672013-01-23 14:39:33.4430
A12013-01-23 14:39:33.4432013-01-23 14:39:46.4030
A12013-01-23 14:39:46.4032013-01-23 14:40:00.1900
A12013-01-23 14:40:00.1902013-01-23 14:40:10.4170
A12013-01-23 14:40:10.4172013-01-24 17:59:01.6471*
A12013-01-24 17:59:01.6472013-01-24 18:01:59.1670
A12013-01-24 18:01:59.1672013-01-24 18:03:54.1400
A12013-01-24 18:03:54.140NULL 0
A22013-01-24 18:17:07.8102013-01-24 18:51:36.6671*
A22013-01-24 18:51:36.6672013-01-24 18:52:46.3100
A22013-01-24 18:52:46.3102013-01-24 18:53:31.8270
A22013-01-24 18:53:31.8272013-01-24 18:53:53.3700
A22013-01-24 18:53:53.3702013-01-24 18:54:19.1970
A22013-01-24 18:54:19.1972013-01-24 18:54:49.5700
A22013-01-24 18:54:49.5702013-01-24 18:55:11.0030
A22013-01-24 18:55:11.0032013-01-24 18:55:32.0300
A22013-01-24 18:55:32.0302013-01-24 18:56:02.3570
A22013-01-24 18:56:02.3572013-01-24 18:56:22.8100
A22013-01-24 18:56:22.8102013-01-25 06:10:02.3831*
A22013-01-25 06:10:02.3832013-01-25 08:52:32.8871*
A22013-01-25 08:52:32.8872013-01-25 08:52:58.4670
A22013-01-25 08:52:58.4672013-01-25 08:53:47.5530
A22013-01-25 08:53:47.553NULL0
A32013-01-24 18:01:03.4132013-01-24 18:13:13.8770*
A32013-01-24 18:13:13.8772013-01-24 18:13:29.3530
A32013-01-24 18:13:29.3532013-01-24 18:13:44.1530
A32013-01-24 18:13:44.1532013-01-24 18:14:00.0270
A32013-01-24 18:14:00.0272013-01-24 18:14:32.6570
A32013-01-24 18:14:32.6572013-01-24 18:15:08.9930
A32013-01-24 18:15:08.9932013-01-24 18:15:42.5270
A32013-01-24 18:15:42.5272013-01-24 18:16:19.9630
A32013-01-24 18:16:19.9632013-01-24 18:16:44.0770
A32013-01-24 18:16:44.077NULL0
在上述表中，ID表示不同的通道，请问如何写一个SQL获取每个通道的第一条记录以及flag为1的记录，结果如上表中“*”的记录
[解决办法]
select ID,[start],[end],flag from(select *,row=row_number()over(partition by ID order by getdate()) from tb)t where row=1 or flag=1
