嘿,伙计们,我有一个mysql表,里面有几条记录,如下图所示!我有如下查询,统计指定时间范围内的记录数( sr13、r4、华为的记录数)。count_r4, count(huawei) as count_huawei from cdrcount where date_time BETWEEN '$date1%' and '$date2%' ");
查询将这
我写了一个查询:WHERE TimeStamp Between 1356908255 AND 13569442551356958655) AND DeviceID = @deviceID 但问题是,它为每个between子句返回多条记录,但我只需要一条记录。LIMIT将限制整个查询的记录总数=1。所以不能用它。