就是这段SQL:SELECT (SELECT COUNT(*) FROM DAP_HOLIDAY WHERE ADJUST=1 AND SWITCH_DATE>=to_date(to_char(to_date('2007-8-2 0:00:00','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),'yyyy-mm-dd') AND SWITCH_DATE<=to_date(to_char(to_date('2007-8-3 0:00:00','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),'yyyy-mm-dd')) AS noHolidayCount,(SELECT COUNT(*) FROM DAP_HOLIDAY WHERE ADJUST=-1 AND SWITCH_DATE>=to_date(to_char(to_date('2007-8-2 0:00:00','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),'yyyy-mm-dd') AND SWITCH_DATE<=to_date(to_char(to_date('2007-8-3 0:00:00','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),'yyyy-mm-dd')) AS holidayCount FROM DAP_HOLIDAY WHERE ROWNUM<=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货