好望角 · 2010-03-18 10:51:10 · 阅读: 416 第二条语句是正确的,可惜时间段有重复,加上distinct又严重影响性能……………… select distinct * from other_table from other_table t1, (select (_time - 60 * 1000) b, (_time + 60 * 1000) e from one_table where event = 123) t2 where t1._time between t2.b and t2.e