以下代码要求: 比如字段是Time,字段必须是DateTime,表名是Tableselect Time from Table where Time >= '2001-1-1 08:00:00' and Time <= '2001-1-1 23:59:59' order by Time UNION select Time from Table where Time >= '2001-1-1 00:00:00' and Time <= '2001-1-1 08:00:00' order by Time其它地方,不能再进行排序哦。否则失效。
比如字段是Time,字段必须是DateTime,表名是Tableselect Time from Table where Time >= '2001-1-1 08:00:00' and Time <= '2001-1-1 23:59:59' order by Time
UNION
select Time from Table where Time >= '2001-1-1 00:00:00' and Time <= '2001-1-1 08:00:00' order by Time其它地方,不能再进行排序哦。否则失效。