select * from RawData
where txtime >= '2005-11-15 6:00:00.000' and txtime <= '2005-11-15 7:00:00.999'
order by servername,fdisname,txname,txtime
where txtime >= '2005-11-15 6:00:00.000' and txtime <= '2005-11-15 7:00:00.999'
order by servername,fdisname,txname,txtime
where txtime between '2005-11-15 6:00:00.000' and '2005-11-15 6:59:59.999'
试下,原因也不清楚