22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM tb WHERE start_date in (SELECT
top 100 percent start_date
FROM
tb
WHERE
1=1 AND start_date >= '2011/3/1 0:00:00' and start_date<= '2011/3/10 0:00:00'
order by
start_date asc)
SELECT
top 1 *
FROM
tb
WHERE
1=1 AND start_date >= '2011/3/1 0:00:00' and start_date<= '2011/3/10 0:00:00'
order by
start_date asc