select * from a where date>=kaishidate and date <=jieshudateselect * from a where '某日期'>=kaishidate and '某日期' <=jieshudateselect * from a where '某日期' between kaishidate and jieshudate
select * from a where kaishidate=<'2009/02/24' and jieshudate>='2009/02/24' 也可以用DATAPART函數
select * from A where kaishidate<=@date and jieshudate>=@date
select * from 表A where date between kaishidate and jieshudate
select * from 表A where date between kaishidate and jieshudate
表A,有二字段kaishidate jieshudate 给定一个date,怎么查询date>=kaishidate并且date <=jieshudate的所有行。 方法一: select *from table where date between 'kaishidate' and 'jieshudate' 方法二: select * from table where date>='kaishidate' and date<='jieshudate'
select * from tb where date>=kaishidate and date<=jieshudate
也可以用DATAPART函數
from A
where kaishidate<=@date and jieshudate>=@date
给定一个date,怎么查询date>=kaishidate并且date <=jieshudate的所有行。
方法一:
select *from table where date between 'kaishidate' and 'jieshudate'
方法二:
select * from table where date>='kaishidate' and date<='jieshudate'
select * from tb where date>=kaishidate and date<=jieshudate