Question

0 0

有个表，里面有xx_id、time和type两个字段，大体是这样

我想查到xx_id相同并对应type为0，1 time时间相差10分钟内的个数，怎么组织sql最高效。

10 years, 10 months ago

share

美丽科学家 10 years, 10 months ago

Answer 1

0


 $time = time() - 600;


 select xx_id,count(xx_id) count from tablename where type = 1 and time > $time group by xx_id;

answered 10 years, 10 months ago

share

qscgul answered 10 years, 10 months ago