34,838
社区成员




select * from Trade where account = '10000002 '
and trade_date > = '2008-3-2' and trade_date < dateadd(d,1,'2008-3-4')
< dateadd(d,1,'2008-3-4')该是小于最后日期
select * from Trade where account = '10000002 ' and trade_date > = '2008-3-2' and trade_date <= '2008-3-5' -- '2008-3-4'
select * from Trade where account = '10000002 ' and trade_date between '2008-3-2' and '2008-3-5' -- '2008-3-4'
select * from Trade where account = '10000002 '
and trade_date > = '2008-3-2' and trade_date <= dateadd(d,1,'2008-3-4')