select * from tablename where datename between('2003-2-15' and '2003-1-12')select top 10 from(select top 30 from tb order by col1 desc) order by col asc
select * from tablename where datename between '2003-2-15' and '2003-1-12'select top 10 * from tablename where f not in (select top 20 f from tablename order by id asc) order by id asc
where f not in (select top 20 f from tablename order by id asc) order by id asc
第二个问题用 friendliu(无为) 就可以解决