select count(*) fromtable where req_time between (当前时间减去一个小时) and 当前时间;
当前时间怎么获得,还有(当前时间减去一个小时)这个这么写?
我的时间类型是:timestamp
select count(*) from ii_mms_snd where req_time between current timestamp(这个地方怎么减一个小时) and current timestamp;
select count(*) from ii_mms_snd where req_time between current timestamp - 1000*60*60 microseconds and current timestamp;
本回答被提问者采纳