数据库地市查询语句

最新推荐文章于 2023-03-05 10:32:05 发布

weixin_30345577

最新推荐文章于 2023-03-05 10:32:05 发布

阅读量120

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/renchong/p/5144419.html

版权

SELECT
    cdl_gen_oid,
    count(cdl_gen_oid)
FROM
    cdl_raw_1x_12501_ztev8_sht_201512
WHERE
    call_start_time >= STR_TO_DATE(
        '2015-12-17 20:00:00',
        GET_FORMAT(DATETIME, 'ISO')
    )
AND call_start_time <= STR_TO_DATE(
    '2015-12-17 20:59:59',
    GET_FORMAT(DATETIME, 'ISO')
)
group by CDL_GEN_OID ORDER BY CDL_GEN_OID
/*
zz 12501
 */

SELECT
    cdl_gen_oid,
    count(cdl_gen_oid)
FROM
    cdl_raw_1x_12501_ztev8_sht_201512
WHERE
    call_start_time >= STR_TO_DATE(
        '2015-12-17 20:00:00',
        GET_FORMAT(DATETIME, 'ISO')
    )
AND call_start_time <= STR_TO_DATE(
    '2015-12-17 20:59:59',
    GET_FORMAT(DATETIME, 'ISO')
)
group by CDL_GEN_OID ORDER BY CDL_GEN_OID

/*
ly 12503
jz  12505
kf  12502
xx  12507
hb 12506
*/

SELECT
    cdl_gen_oid,
    count(cdl_gen_oid)
FROM
    cdl_raw_1x_12501_ztev8_sht_201512
WHERE
    call_start_time >= STR_TO_DATE(
        '2015-12-17 20:00:00',
        GET_FORMAT(DATETIME, 'ISO')
    )
AND call_start_time <= STR_TO_DATE(
    '2015-12-17 20:59:59',
    GET_FORMAT(DATETIME, 'ISO')
)
group by CDL_GEN_OID ORDER BY CDL_GEN_OID
/*
AY 12508
SMX 12512
XC 12510
PY 12509
LH 12511
SQ 12514

*/

SELECT
    cdl_gen_oid,
    count(cdl_gen_oid)
FROM
    cdl_raw_1x_12517_ztev8_sht_201512
WHERE
    call_start_time >= STR_TO_DATE(
        '2015-12-17 20:00:00',
        GET_FORMAT(DATETIME, 'ISO')
    )
AND call_start_time <= STR_TO_DATE(
    '2015-12-17 20:59:59',
    GET_FORMAT(DATETIME, 'ISO')
)
group by CDL_GEN_OID ORDER BY CDL_GEN_OID
/*
ZMD 12517
PDS 12504
NY 12513
XY 12515
ZK 12516
*/