72tarv4qh6fb0
SELECT DISTINCT "Timestamp" AS writeTime,
100*("snmpResultZero"/("snmpResultZero"+"snmpResultOne")) calcResult,
"snmpResultZero"
FROM KIS_SNMP
WHERE "OidGroup" ='MemoryUtilization_cisco_1_0'
AND "Host" ='199.0.62.53'
AND "Timestamp" >='1130922091500000'
AND "Timestamp" <='1131022091500000'
AND 100 *("snmpResultZero"/("snmpResultZero"+"snmpResultOne")) IS NOT NULL
AND 0 <>("snmpResultZero"+"snmpResultOne")
ORDER BY "Timestamp"
0wa43q1p9dh22
SELECT DISTINCT "Timestamp" AS writeTime,
"OidGroup",
100*("snmpResultZero"/("snmpResultZero"+"snmpResultOne")) ?′灻?ê
FROM KIS_SNMP
WHERE ("OidGroup"='MemoryUtilization_cisco_1_0')
AND "Host" ='40.52.240.65'
AND "Timestamp" >='1130918091047000'
AND "Timestamp" <='1131018091047000'
AND 0 <>("snmpResultZero"+"snmpResultOne")
ORDER BY "Timestamp"
a450vquwbsa8p
SELECT DISTINCT "Timestamp" AS WRITETIME,
"snmpResultZero" AS CALCRESULT
FROM itmuserdc.KIS_SNMP
WHERE "Host" = '199.0.27.68'
AND ("OidGroup" = 'ifUtilizationIn_general_55'
OR "OidGroup" = 'ifUtilizationInHC_general_55')
AND "Timestamp" >= '1130930000000000'
AND "Timestamp" <= '1131031171224000'
AND "snmpResultZero" IS NOT NULL
AND to_number("snmpResultZero") > 0
ORDER BY "Timestamp"
这3个SQL文本区别还是不小的,不清楚你为什么 要放3个不同SQL的 前后对比