数据库地市查询语句 

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
*/

 

　　

posted @ 2016-01-20 11:10  自由石匠  阅读(186)  评论(0)  编辑  收藏  举报