如何在DutyDate的两个datetime之间添加查询条件

SQL select pivot declare @s nvarchar(4000) Select @s=isnull(@s+",","")+quotename([DutyDate]) from DutyInfo group by [DutyDate] exec("select * from DutyInfo pivot (max([DutyName]) for [DutyDate] in("+@s+"))b ")
	declare @s nvarchar(4000) Select @s=isnull(@s+",","")+quotename([DutyDate]) from DutyInfo group by [DutyDate] where DutyDate between A and B exec("select * from DutyInfo pivot (max([DutyName]) for [DutyDate] in("+@s+"))b ") /pre>
40分	declare @s nvarchar(4000) Select @s=isnull(@s+",","")+quotename([DutyDate]) from DutyInfo group where DutyDate between A and B y [DutyDate] exec("select * from DutyInfo pivot (max([DutyName]) for [DutyDate] in("+@s+"))b ") /pre>
	这是oracle sql的高级用法吧，你google 搜下语法呢，oracle的document一般都非常详细吧