ืืืขืื ืืื ืืืจ ืืึธืื ืฆื ืึทืคึผืืึทืืืื ืื PostgreSQL ืึธื ืคึฟืจืขื ืืื ืืืึธืก ืืขืงืืืขื ืืืืก ืคืื ืขืก ืึทืืข.
ืคืืจืืืืก ืืืกืื ืืขืืืื? ืื, ืืืืื ืื ืคืจืืขืจืืืืข 4 ืืืจ ืืื ืืืฅ ืืขืืจืืขื ืฉืืืืขืจืืืื, ืจืืืื, ืืื ื ืืืืืขืจ ืืืงืขื.
ืืื ืึทื ืขืคึผืืืจืึทืฃ.
ืืึทืืืจื ืืืืฃ ืคืึทืงืืืฉ ืืขืฉืขืขื ืืฉื.
ืึทืืข ื ืขืืขื ืืึธืื ืฉืืื ืืขืืืื, ืงืึธืืื ืกืึทืืึทื ืกืื ืืขื ืขื ืืจืึทืค.
ืืืขื ืืืจ ืืขืจืืจืืืื ืึท ืืืืขืจ ืจืขืืืืืึทื, ืขืก ืืื ืฉืืขื ืืืง ืืฉืืงืึทืืืข ืฆื ืืขืืขื ืงืขื ืืืึธืก ืืื ืืขืืืขื ืื ืืืคึผืึทืืึทืก ืคึฟืึทืจ ืื ืึธื ืืืื, ืืื ืขืก ืึทืืข ืื ืืขืืืืื.
ืึทืืื, ืืืึธืก ืืขืืจืืคื ืืื ืึท ืจืขืืืืืึทื ืืื ืืขืงืืฆืขืจ ืืืกืงืจืืืื ืืื ืืขื ืึทืจืืืงื "'.
ืขืก ืืืขื ืืืกืืึธืืข ืืืื ืืฉืืงืึทืืืข ืฆื ืจืืงืจืืืื ืื ืงืืื ืคืื ืคืจืืึทืขืจืืืง ืืขืฉืขืขื ืืฉื.
ืื ืืขืฉืืืืข ืืขืจืืืขืืืขื ืื ืคึผืื ืืืขื ืึธื ืืืื ืืึธื - 2018-09-10 18:02:48.
ืืืื, ืืื ืืขืจ ืืขืฉืืืืข ืขืก ืืื ืึท ืืงืฉื ืคืื ืืืึธืก ืขืก ืึทืืข ืื ืืขืืืืื:
ืคึผืจืึธืืืขื ืืขืืืืืืกืงืืืึทืื
"PARAMETER_ID" ืืื ืคึผืึทืจืึทืืขืืขืจ_ืื,
pd."PD_NAME" ืืื pd_name,
pd."CUSTOMER_PARTNUMBER" ืืื ืงืื ื_ืคึผืึทืจืื ืืืขืจ,
ืื. "ืืจื" ืืื ืืจื,
w. "LOTID" ืืื ืืึธืืื,
w.โRTD_VALUEโ ืืื RTD_value,
w.โLOWER_SPEC_LIMITโ ืืื ื ืืืขืจืืงืขืจ_ืกืคึผืขืง_ืืืืื,
w.โUPPER_SPEC_LIMITโ ืืื ืืืืืขืจืฉืืขืจ_ืกืคึผืขืง_ืืืืื,
p."TYPE_CALCUL" ืืื ืืืคึผ_ืงืึทืืงืื,
s."SPENT_NAME" ืืื ืคืืจืืจืืื_ื ืืืขื,
"SPENT_DATE" ืืื ืคืืจืืจืืื_ืืึทืืข,
ืขืงืกืืจืึทืงื (ืืึธืจ ืคึฟืื "SPENT_DATE") ืืื ืืึธืจ,
ืขืงืกืืจืึทืงื (ืืืืฉ ืคืื "SPENT_DATE") ืืื ืืืืฉ,
s."REPORT_NAME" ืืื ืจืขืคึผืึธืจื_ื ืึทืืข,
p."STPM_NAME" ืืื ืกืืคึผื_ื ืึธืืขื,
"CUSTOMERPARAM_NAME" ืืื ืงืื ื ืคึผืึทืจืึทื_ื ืึทืืข
ืคึฟืื wdata w,
ืคืืจืืจืืื ืก,
pmtr p,
spend_pd sp,
pd pd
WHERE s."SPENT_ID" = w."SPENT_ID"
ืืื ืคึผ."PARAMETER_ID" = w."PARAMETER_ID"
ืืื s.โSPENT_IDโ = sp.โSPENT_IDโ
ืืื pd."PD_ID" = sp."PD_ID"
ืืื s.โSPENT_DATEโ >= '2018-07-01' ืืื s.โSPENT_DATEโ <= '2018-09-30'
ืืื s. "SPENT_DATE" = (SELECT MAX(s2."SPENT_DATE")
ืคืื ืคืืจืืจืืื ืก 2,
wdata w2
WHERE s2.โSPENT_IDโ = w2.โSPENT_IDโ
ืืื ืื2. "ืืจื" = ืื. "ืืจื");
ืืึทืฉืจืืึทืืื ื ืคืื ืื ืคึผืจืึธืืืขื ืืื ืคึผืจืืืืงืืึทืืื ื ืึธืจืืึทื - "ืึทืืฅ ืืื ืฉืืขืื. ืืื ืืืจ ืืืืก ืื ืคืจืืืืขื ืืื. โ
ืืื ืืื ืืืืื ืืขืืขื ืงื ืื ืื ืขืงืืืืข ืคืื โโืื ืฆืืื ืคืื ืืจืื ืืื ื ืืืื ืืื ืืฉ ืืจืืืืืขื:
ืงืืื ืืขืจ ืืืืขืจ ืฆืื ืืขืงืขืจ.
-ืืึธืจื ืืฉื ืึทืจืืขื ืคึฟืึทืจ ืืืจ, ืืึธืื ืืืจ ืืื ืื ืคึผืจืึธืืืขื ืืื.
- ืืื ืื ืึท ...
ืืืขืจ ืคืื ืงืืจืก, ืืึธืก ืืื ื ืืฉื ืืขืจ ืืืขื ืฆื ืกืึธืืืืข ืคืึธืจืฉืืขืืื ื ืื ืกืึทืืึทื ืฅ. "ืืื ืงืขื ื ืืฉื ืคึฟืึทืจืฉืืืื ืืื ืื"(ืืื). ืืืจ ืืึทืจืคึฟื ืฆื ืจืขืืขื ืขื ืขืก ืืืืก.
ื ื, ืืึธืืืจ ืืจืึธืื. ืืคึฟืฉืจ ืขืคึผืขืก ืืืขื ืึธื ืงืืืึทืื ืืื ืึท ืจืขืืืืืึทื.
ืื ืืืืกืคืึธืจืฉืื ื ืืึธื ืืื ืึธื ืืขืืืืื
ืึทืืื, ืืืึธืก ืงืขื ืขื ืืืื ืืขืืขื ืืื ืืื ืื ื ืึทืงืขื ืืืื, ืึธื ืืคืืื ืจืืืึธืจื ืฆื ืืขืจืงืืขืจื.
1) JOINs ืืขื ืขื ื ืืฉื ืืขื ืืฆื. ืืึธืก ืืื ืฉืืขืื, ืกืคึผืขืฆืืขื ืืืื ืื ื ืืืขืจ ืคืื ืงืึทื ืขืงืฉืึทื ื ืืื ืืขืจ ืืื ืืืื.
2) ืึธืืขืจ ืืืึธืก ืืื ืืคืืื ืขืจืืขืจ ืืื ืงืึธืจืึทืืืืืึทื ืกืึทืืงืืืขืจืื, ืืขืจืฆื, ืืื ืึทืืืจืขืืึทืืืึธื. ืืืก ืืื ืืืืขืจ ืฉืืขืื.
ืืึธืก ืืื ืืึธื ืฉืืขืื. ืืืขืจ ืืืก ืืื ื ืืจ ืคืื ืืืื ืืืื. ืคืื ืื ืื ืืขืจืข ืืืื ืืื ืืืก ืืืืขืจ ืืื, ืืืืื ืื ืคืจืืืืขื ืืื ืงืืืจ ื ืืืืืื ื ืืื ื ืืงืฉื ืืืืก ืืขื ืงืขื ืคืืจืืขืกืขืจื.
ืืฒ ื ืืฉ ื ืฆ ื ื ืืืืืจ ( ื ) .
ืื ืึธื ืคึฟืจืขื ืคึผืืึทื ืืื ื ืืฉื ืึทืืื ืงืึธืืคึผืืืฆืืจื, ืึธืืขืจ ืขืก ืืื ืืึทื ืฅ ืื ืืืงืึทืืืื:
ืืืจืืคืืจืื ื ืคึผืืึทื
ืื ืืขืจืกื ืืฉืืงืึทืืืข ืืื ื ืืฆืืง, ืืื ืืขืืืืื ืืืขื, ืืื ืืื ืื ืึธื ืืืื ืืื ืกืืฃ.
ื ืขืกืืขื ืฉืืืืฃ (ืงืึธืกื = 935.84..479763226.18 ืจืึธืื = 3322 ืืจืืื = 135) (ืคืึทืงืืืฉ ืฆืืื = 31.536..8220420.295 ืจืึธืื = 8111656 ืืืคึผืก = 1)
ืคึผืืึทื ืืจืื ื ืฆืืื: 3.807 ืืื
ืืืจืืคืืจืื ื ืฆืืื: 8222351.640 ืืื
ืงืึทืืคึผืืืฉืึทื ืฆืืึทื ืืื ืืขืจ ืืื 2 ืฉืขื.
ืคืึทืืฉืข ืืืืคึผืึทืืึทืกืึทื ืืืึธืก ืืขื ืืืขื ืฆืืื
ืืืคึผืึธืืืขืกืืก 1 - ืื ืึธืคึผืืืืืืขืจ ืืืื ืึท ืืจืืึทื ืืื ืืืืขื ืืขื ืืืืจืขืื ืคึผืืึทื.
ืฆื ืืืืืฉืืืึทืืืื ืื ืืืจืืคืืจืื ื ืคึผืืึทื, ืืืจ ืืืขืื ื ืืฆื ืืขื ืคึผืืึทืฅ . ืึธืืขืจ, ืืขืจ ืคึผืืึทืฅ ืืื ื ืืฉื ืืืืึทืื ืขืคึผืขืก ืืฉืืงืึทืืืข ืึธืืขืจ ื ืืฆืืง. ืืื ืขืจืฉืืขืจ ืืื ืจืืข ืืืืง, ืขืก ืืื ืืึธืจื ืืฉื ืืืึธืก ืงืขื ืืึทืงืข ืืขืืคื. ืืื ืขืก ืืขืืืขื ืึทื ืืึทื ืฅ ืกืงืึทื ืืื ืืื ืืืึทื. ืืื ืืืืืืขืจ.
ืืืคึผืึธืืืขืกืืก 2-ืืืคึผืึทืงื ืืืืฃ ืื ืืึทืืข ืคืื โโืื ืึทืืืึธืืืึทืงืืื ืืืึทื, ืืืจ ืืึทืจืคึฟื ืฆื ืืึทืงืืืขื ืืึทืคืจืืึทืขื ืคืื ืื ืืจืึทืงืขืก.
ืืืขืจ ืื ืึทืืืึธืืืึทืงืืื ืืขืืึธื ืก ืืืืืืืื ืืขืืื ื, ืขืก ืืขื ืขื ืงืืื ืืึทื ื-ืืึทื ืืืื ื ืคึผืจืึทืกืขืกืึทื. ืงืืื ืขืจื ืกื ืืึทืกืข. ืืืจ ืืึทืจืคึฟื ืฆื ืงืืงื ืคึฟืึทืจ ืขืคึผืขืก ืึทื ืืขืจืฉ.
ืืืคึผืึธืืืขืกืืก 3 - ืกืืึทืืืกืืืง ืืื ืึทืืืืืืืื, ืึทืืฅ ืืึทืจืฃ ืืืื ืจืืงืึทืืงืืึทืืืืืื
ืืืืืขืจ, ื ืืฉื ืึทื. ืื ืกืืึทืืืกืืืง ืืขื ืขื ืืขืจืืืึทื ืืืงื. ืืืึธืก, ืืขืืขืื ืื ืคืขืื ืคืื ืคึผืจืึธืืืขืืก ืืื ืึทืืืึธืืืึทืงืืื, ืืื ื ืืฉื ืืืืืฉ.
ืืื ืก ืึธื ืืืืื ืึธืคึผืืืืืืื ื
ืื ืืืืคึผื ืืืฉ 'ืืืืึทืืึท' ืืื ืืืืขืจ ื ืืฉื ืงืืืื, ืึผืืขื 3 ืืืืืึธื ืจืขืงืึธืจืืก.
ืืื ืืึธืก ืืื ืืขืจ ืืืฉ ืืืึธืก ืืึทื ืฅ ืกืงืึทื ืืืื.
ืืึทืฉ ืงืึธื ื: ((ืื."SPENT_ID" = s."SPENT_ID") ืืื ((ืกืืืคึผืืึทื 1) = s."SPENT_DATE"))
-> ืกืขืง ืกืงืึทื ืืืืฃ wdata w (ืงืึธืกื=0.00..574151.49 ืจืึธืื=26886249 ืืจืืื=46) (ืคืึทืงืืืฉ ืฆืืื=0.005..8153.565 ืจืึธืื=26873950 ืืืคึผืก=1)
ืืืจ ืืึธื ืื ื ืึธืจืืึทื ืืึทื: "ืงืื, ืืึธืืืจ ืืึทืื ืึทื ืืื ืืขืงืก ืืื ืึทืืฅ ืืืขื ืคืืืขื."
ืืืฉืืคื ืึทื ืืื ืืขืงืก ืืืืฃ ืื "SPENT_ID" ืคืขืื
ืืื ื ืจืขืืืืืื:
ืึธื ืคึฟืจืขื ืืืจืืคืืจืื ื ืคึผืืึทื ื ืืฆื ืืื ืืขืงืก
ื ื, ืืื ืขืก ืืขืืืืคื?
ืืื ืืขืืืขื: 8 222 351.640 ืืื (ืึท ืืืกื ืืขืจ ืืื 2 ืฉืขื)
ืืขืฐืืจื: 6 985 431.575 ืืื (ืึผืืขื 2 ืฉืขื)
ืืื ืึทืืืขืืืื, ืื ืืขืืืข apples, ืืืึทื ืืืื ืื ื.
ืืึธืืืจ ืืขืืขื ืงืขื ืื ืงืืึทืกืืงืก:
โ ืืึธื ืืืจ ืื ืืขืืืข, ืึธืืขืจ ืึธื ืคึฟืืืืืขื? ืืืขื ืืืื".
ืืื ืคึผืจืื ืฆืืคึผ, ืืึธืก ืงืขื ืืืื ืืขืจืืคื ืึท ืืื ืจืขืืืืืึทื, ื ื, ื ืืฉื ืืื, ืึธืืขืจ ืคึผืึทืกืืง. ืืื ืืื ืืกืืขืจ, ืฆืืฉืืขืื ืึท ืืจืืืก ืืึทืจืืื ืฆื ืืขืจ ืงืื ื ืืืกืงืจืืืืื ื ืืื ืคืื ืืื ืฉืืื ืืขืืื ืืื ืืืึธืก ืืืึธืก ืืื ืืขืืืขื ืืขืืื ืืื ืืื.
ืึธืืขืจ ื ืึธื, ืืขืจ ืืขืฆื ืืึทืฉืืืก ืืื ื ืึธื ืืืืึทื ืึทืืืขืง. ืืืืขืจ ืืืืื.
ืืื ืืืฆื ืื ืืขืจืกื ืืฉืืงืึทืืืข ืืึทื - ืืืจ ืคืึธืจืืขืฆื ืฆื ืึทืคึผืืึทืืืื, ืืืจ ืืืขืื ืคืืืืืฉ ืื ืืงืฉื
ืฉืจืื ืืืื - ื ืืฆื JOIN
ืื ืจืืจืืื ืืงืฉื ืืืฆื ืงืืงื ืืื ืืึธืก (ื ื ืืื ืืื ืืกืืขืจ ืืขืจ ืฉืืื):
ืึธื ืคึฟืจืขื ื ืืฆื JOINืืืืกืงืืืึทืื
"PARAMETER_ID" ืืื ืคึผืึทืจืึทืืขืืขืจ_ืื,
pd."PD_NAME" ืืื pd_name,
pd."CUSTOMER_PARTNUMBER" ืืื ืงืื ื_ืคึผืึทืจืื ืืืขืจ,
ืื. "ืืจื" ืืื ืืจื,
w. "LOTID" ืืื ืืึธืืื,
w.โRTD_VALUEโ ืืื RTD_value,
w.โLOWER_SPEC_LIMITโ ืืื ื ืืืขืจืืงืขืจ_ืกืคึผืขืง_ืืืืื,
w.โUPPER_SPEC_LIMITโ ืืื ืืืืืขืจืฉืืขืจ_ืกืคึผืขืง_ืืืืื,
p."TYPE_CALCUL" ืืื ืืืคึผ_ืงืึทืืงืื,
s."SPENT_NAME" ืืื ืคืืจืืจืืื_ื ืืืขื,
"SPENT_DATE" ืืื ืคืืจืืจืืื_ืืึทืืข,
ืขืงืกืืจืึทืงื (ืืึธืจ ืคึฟืื "SPENT_DATE") ืืื ืืึธืจ,
ืขืงืกืืจืึทืงื (ืืืืฉ ืคืื "SPENT_DATE") ืืื ืืืืฉ,
s."REPORT_NAME" ืืื ืจืขืคึผืึธืจื_ื ืึทืืข,
p."STPM_NAME" ืืื ืกืืคึผื_ื ืึธืืขื,
"CUSTOMERPARAM_NAME" ืืื ืงืื ื ืคึผืึทืจืึทื_ื ืึทืืข
ืคึฟืื wdata ืืื ืื ืขืจ JOIN ืคืืจืืจืืื ืืืืฃ ืื.โSPENT_IDโ=s.โโSPENT_IDโ
ืื ืขืจ JOIN pmtr p ON p.โPARAMETER_IDโ = w.โPARAMETER_IDโ
ืื ืขืจ JOIN spent_pd sp ON s."SPENT_ID" = sp."SPENT_ID"
ืื ืขืจ JOIN pd pd ON pd.โPD_IDโ = sp.โPD_IDโ
ืืืื
s. "SPENT_DATE" >= '2018-07-01' ืืื s."SPENT_DATE" <= '2018-09-30'AND
s.โSPENT_DATEโ = (SELECT MAX(s2.โSPENT_DATEโ)
ืคึฟืื wdata w2 ืื ืขืจ JOIN ืคืืจืืจืืื s2 ืืืืฃ w2.โSPENT_IDโ=s2.โSPENT_IDโ
ืื ืขืจ JOIN wdata w
ืืืืฃ ืื2. "ืืจื" = ืื. "ืืจื");
ืคึผืืึทื ืืจืื ื ืฆืืื: 2.486 ืืื
ืืืจืืคืืจืื ื ืฆืืื: 1223680.326 ืืื
ืึทืืื, ืืขืจ ืขืจืฉืืขืจ ืจืขืืืืืึทื.
ืืื ืืขืืืขื: 6 ืืื (ืึผืืขื 985 ืฉืขื).
ืืขืฐืืจื: 1 223 680.326 ืืก (ื ืึธืจ ืืืืขืจ 20 ืืื ืื).
ืืื ืจืขืืืืืึทื. ืืื ืคึผืจืื ืฆืืคึผ, ืืืืืขืจ, ืืืจ ืงืขื ืืึทืืื ืืึธืจื. ืืืขืจ ืขืก ืืื ืึทืืื ืึทื ืื ืืจืึทืกืืื ื, ืืืจ ืงืขื ืขื ื ืืฉื ืืึทืืื.
ืืืึธ
ืฉืจืื ืฆืืืื - ืืึทืงืืืขื ืืึทืคืจืืึทืขื ืคืื ืื ืงืึธืจืึทืืืืืึทื ืกืึทืืงืืืขืจื
ืืขืขื ืืขืจื ืืขืื ืืขืงืกื:
ืึธื ืงืึธืจืึทืืืืืึทื ืกืึทืืงืืืขืจืืืืืกืงืืืึทืื
"PARAMETER_ID" ืืื ืคึผืึทืจืึทืืขืืขืจ_ืื,
pd."PD_NAME" ืืื pd_name,
pd."CUSTOMER_PARTNUMBER" ืืื ืงืื ื_ืคึผืึทืจืื ืืืขืจ,
ืื. "ืืจื" ืืื ืืจื,
w. "LOTID" ืืื ืืึธืืื,
w.โRTD_VALUEโ ืืื RTD_value,
w.โLOWER_SPEC_LIMITโ ืืื ื ืืืขืจืืงืขืจ_ืกืคึผืขืง_ืืืืื,
w.โUPPER_SPEC_LIMITโ ืืื ืืืืืขืจืฉืืขืจ_ืกืคึผืขืง_ืืืืื,
p."TYPE_CALCUL" ืืื ืืืคึผ_ืงืึทืืงืื,
s."SPENT_NAME" ืืื ืคืืจืืจืืื_ื ืืืขื,
"SPENT_DATE" ืืื ืคืืจืืจืืื_ืืึทืืข,
ืขืงืกืืจืึทืงื (ืืึธืจ ืคึฟืื "SPENT_DATE") ืืื ืืึธืจ,
ืขืงืกืืจืึทืงื (ืืืืฉ ืคืื "SPENT_DATE") ืืื ืืืืฉ,
s."REPORT_NAME" ืืื ืจืขืคึผืึธืจื_ื ืึทืืข,
p."STPM_NAME" ืืื ืกืืคึผื_ื ืึธืืขื,
"CUSTOMERPARAM_NAME" ืืื ืงืื ื ืคึผืึทืจืึทื_ื ืึทืืข
ืคึฟืื ืืืืึทืืึท ืืื ืื ืขืจ JOIN ืคืืจืืจืืื ืืืืฃ s.โSPENT_IDโ = w.โSPENT_IDโ
ืื ืขืจ JOIN pmtr p ON p.โPARAMETER_IDโ = w.โPARAMETER_IDโ
ืื ืขืจ JOIN spent_pd sp ON s."SPENT_ID" = sp."SPENT_ID"
ืื ืขืจ JOIN pd pd ON pd.โPD_IDโ = sp.โPD_IDโ
ืื ืขืจ ืคืึทืจืืื ืื (ืกืขืืขืงืืืจื w2.โLRMโ, MAX(s2.โSPENT_DATEโ)
ืคึฟืื ืคืืจืืจืืื s2 ืื ืขืจ JOIN wdata w2 ืืืืฃ s2.โSPENT_IDโ = w2.โSPENT_IDโ
GROUP BY w2.โLRMโ
) ืื ืืืืฃ ืื.โืืจืโ = ืื.โืืจืโ
ืืืื
s."SPENT_DATE" >= '2018-07-01' ืืื s."SPENT_DATE" <= '2018-09-30';
ืคึผืืึทื ืืจืื ื ืฆืืื: 2.291 ืืื
ืืืจืืคืืจืื ื ืฆืืื: 165021.870 ืืื
ืืื ืืขืืืขื: 1 223 680.326 ืืก (ื ืึธืจ ืืืืขืจ 20 ืืื ืื).
ืืขืฐืืจื: 165 021.870 ืืื (ื ืึธืจ ืืืืขืจ 2 ืืื ืื).
ืืืก ืืื ืฉืืื ืืื ืฅ ืืื.
ืึธืืขืจ, ืืื ืื ืืจืืืืฉ ืืึธืื "ืึธืืขืจ, ืขืก ืืื ืฉืืขื ืืืง ืึท ืึธืืขืจ" ื ืจืขืืืืืึทื ืืืึธืก ืืื ืฆื ืืื ืืึธื ืืืืืึธืืึทืืืฉ ืึทืจืืืกืจืืคื ืืฉื. ืขืคึผืขืก ืืื ืคืึทืืฉ ืืึธ.
ืื ืืืืคึผืึทืืึทืกืึทืก ืืืขืื ืงืขืจืขืงืืื ื ืื ืึธื ืคึฟืจืขื ืฆื ืืึทืงืืืขื ืืึทืคืจืืึทืขื ืคืื ืื ืงืึธืจืึทืืืืืึทื ืกืึทืืงืืืขืจื ืืื ืจืืืืืง. ืึธืืขืจ ืืืจ ืืึทืจืคึฟื ืฆื ืืืืืง ืขืก ืึท ืืืกื ืคึฟืึทืจ ืื ืืขืฆื ืจืขืืืืืึทื ืฆื ืืืื ืจืืืืืง.
ืืื ืึท ืจืขืืืืืึทื, ืืขืจ ืขืจืฉืืขืจ ืื ืืขืจืืืืืื ืจืขืืืืืึทื:
ืขืืืืื ืึธื ืคึฟืจืขื ืึธื ืงืึธืจืึทืืืืืึทื ืกืึทืืงืืืขืจืืืืืกืงืืืึทืื
"PARAMETER_ID" ืืื ืคึผืึทืจืึทืืขืืขืจ_ืื,
pd."PD_NAME" ืืื pd_name,
pd."CUSTOMER_PARTNUMBER" ืืื ืงืื ื_ืคึผืึทืจืื ืืืขืจ,
ืื. "ืืจื" ืืื ืืจื,
w. "LOTID" ืืื ืืึธืืื,
w.โRTD_VALUEโ ืืื RTD_value,
w.โLOWER_SPEC_LIMITโ ืืื ื ืืืขืจืืงืขืจ_ืกืคึผืขืง_ืืืืื,
w.โUPPER_SPEC_LIMITโ ืืื ืืืืืขืจืฉืืขืจ_ืกืคึผืขืง_ืืืืื,
p."TYPE_CALCUL" ืืื ืืืคึผ_ืงืึทืืงืื,
s."SPENT_NAME" ืืื ืคืืจืืจืืื_ื ืืืขื,
"SPENT_DATE" ืืื ืคืืจืืจืืื_ืืึทืืข,
ืขืงืกืืจืึทืงื (ืืึธืจ ืคึฟืื "SPENT_DATE") ืืื ืืึธืจ,
ืขืงืกืืจืึทืงื (ืืืืฉ ืคึฟืื ื. "SPENT_DATE") ืืื ืืืืฉ,
s."REPORT_NAME" ืืื ืจืขืคึผืึธืจื_ื ืึทืืข,
p."STPM_NAME" ืืื ืกืืคึผื_ื ืึธืืขื,
"CUSTOMERPARAM_NAME" ืืื ืงืื ื ืคึผืึทืจืึทื_ื ืึทืืข
ืคึฟืื ืืืืึทืืึท ืืื ืื ืขืจ JOIN ืคืืจืืจืืื ืืืืฃ s.โSPENT_IDโ = w.โSPENT_IDโ
ืื ืขืจ JOIN pmtr p ON p.โPARAMETER_IDโ = w.โPARAMETER_IDโ
ืื ืขืจ JOIN spent_pd sp ON s."SPENT_ID" = sp."SPENT_ID"
ืื ืขืจ JOIN pd pd ON pd.โPD_IDโ = sp.โPD_IDโ
ืื ืขืจ JOIN (ืกืขืืขืงืืืจื w2.โLRMโ, MAX(s2.โSPENT_DATEโ) ืืื โSPENT_DATEโ
ืคึฟืื ืคืืจืืจืืื s2 ืื ืขืจ JOIN wdata w2 ืืืืฃ s2.โSPENT_IDโ = w2.โSPENT_IDโ
GROUP BY w2.โLRMโ
) ืื ืืืืฃ ืื.โืกืคึผืขื ื_ืืึทืืขโ = ื.โืกืคึผืขื ื_ืืึทืืขโ ืืื ืื.โืืจืโ = ืื.โืืจืโ
ืืืื
s."SPENT_DATE" >= '2018-07-01' ืืื s."SPENT_DATE" <= '2018-09-30';
ืคึผืืึทื ืืจืื ื ืฆืืื: 3.192 ืืื
ืืืจืืคืืจืื ื ืฆืืื: 208014.134 ืืื
ืึทืืื, ืืืึธืก ืืืจ ืขื ืืืงื ืืื ืืื ืืขืจ ืขืจืฉืืขืจ ืคึผืึทืกืืง ืจืขืืืืืึทื, ืืืึธืก ืืื ื ืืฉื ืึท ืฉืึธื ืฆื ืืืืึทืื ืฆื ืืขืจ ืงืื ื:
ืื ืืขืืืืื ืืื: 8 222 351.640 ืืก (ืืขืจ ืืื 2 ืฉืขื)
ืืืจ ืืขืจืืื ืฆื ืืขืจืืจืืืื: 1 ืืื (ืึท ืืืกื ืืขืจ ืืื 223 ืืื ืื).
ืจืขืืืืืึทื (ืฆืืืืฉื): 208 014.134 ืืื (ื ืึธืจ ืืืืขืจ 3 ืืื ืื).
ืืืกืืขืฆืืืื ื ืจืขืืืืืึทื.
ืืึทื ืฅ
ืื ืจ ืืื ื ืืืจ ื ืืขืงืขื ื ืืคืฉืืขืื .
ืึธืืขืจโฆ
ืึทืคึผืขืืื ืงืืื ืืื ืขืกื. ืืขืจ ืฐืึธืก ืืฒื ืฐืขื ืืขืื ืืขื ืฐืขื. ืงืืื ืจืขืืืืืึทื ืืื ืื ืืขืจืืืืืื. ืืคืืขืฉืืขืื ืืื ืืขืฉืืืจืื. ืืื"ื ื
ืืื ืก ืคืึธืจืืขืฆื ืึทืคึผืืึทืืึทืืืืฉืึทื.
ืืืืข ืืขืืื ืง. ืกืคึผืขืฆืืขื ืงืึทื ืกืืืขืจืื ื ืึทื ืืขืจ ืงืื ื ืืื ื ืืฉื ืึทืคึฟืืื ืืืื ืื ื. ืืื ืืคืืื ืฉืืืจืง ืืขืจืคืืจ.
ืึทืืื, ืขืก ืืื ืฆืืื ืคึฟืึทืจ ืึท ืืึทืืึทืืืืก ืจืืืืืืื. ืื ืึธื ืคึฟืจืขื ืกืืจืืงืืืจ ืืื ืงืขื ืขื ื ืื ืืขืจ ืืืื ืึธืคึผืืืืืืขื (ืืึธืืฉ, ืืื ืขืก ืคืืจืงืขืจื ืืืืก ืฉืคึผืขืืขืจ, ืขืก ืืื ืึทื ืึธืคึผืฆืืข ืฆื ืขื ืฉืืจ ืึทื ืึทืืฅ ืึทืงืฉืื ืคืืืื). ืึธืืขืจ ืฆื ืึธื ืืืืื ืึธืคึผืืืืืืื ื ืืื ืืขืืืขืืึธืคึผืื ื ืื ืืึทืืึทืืืืก ืคึผืืึทื ืืื ืฉืืื ืึท ืืืืขืจ ืคึผืจืึทืืึทืกืื ื ืืขืืึทื ืง. ืืื ืจืืึฟ ืืืคึผืึธืจืืึทื ืืื ืืฉืืงืึทืืืข. ืืืืืขืจ, ืืขืืขื ืง ืืืื ืืืื ื. ืืื ืืื ื ืืฉื ืืืืื ืืขืืืืจื ืึท ืืืึท, ืืื ืืขืืืืงืกื ืืื ืึท ืคึผืจืึธืืจืึทืืืกื (BASIC, ืึทืกืขืืืืขืจ, C, ืืึธืคึผื-ืคึผืืืก C, ืึธืจืึทืงืืข, ืคึผืกืงืงื). ืึท ืืื ืืขืจืขืกืึทื ืืข ืืขืืข, ืคึฟืึทืจืฉืืืื ืืื, ืคึฟืึทืจ ืึท ืืึทืืื ืืขืจื ืืืจืื ;-).
ืึธืืขืจ, ืืึธืืืจ ื ืืฉื ืืึทืงืืืขื ืืืกืืจืึทืงืืึทื.
ืืืื,
ืึธืืขืจ ืืึธืืขืจ ืฆืขืืืืืื ื ืืืขื ืืขืืคื ืืื ืื?
ืกืคึผืืืืขืจ - "ืืึธ, ืขืก ืืขืืึธืืคึฟื, ืึทืจืืึทื ืืขืจืขืื ื ืืื ืึธืคึผืืืืืืื ื ืคืึธืจืฉืืขืืื ื."
ืืืขืจ ืืืก ืืื ืืืจ ืื ืื ืืขืจืข ืืขืฉื...
ืืืฉื...
ืืงืืจ: www.habr.com