SQL分类后每类随机抽取
摘要:
declare @tta datetime, @i int set @tta='2013-1-10 00:00:00' set @i=0 while @tta < '2013-2-11 00:00:00'begin--select DATEADD(HH,1, @tta)-- select top 1 * From tibet where "通话时间">@tta and "通话时间"< DATEADD(HH,1,@tta) order by "通话时间"insert into tibac 阅读全文
posted @ 2013-02-19 19:19 evander 阅读(465) 评论(0) 推荐(0)
浙公网安备 33010602011771号