Oracle limit calculation for a great god for help-CodePudding

 SELECT arjun C, B.M C, MAX (c. C) to heavy columns, MAX (arjun C | | '| | | B.M C | |' | | | c. C) after the binding name, MIN ((A.C Y + biggest Y + Arthur c. Y)/(be sad R chtistina georgina rossetti.british poetess al-qeada B.G R + R + + 0.01) * 100) line loss.suggestions 
The FROM T_PD_XS_YXS A, T_PD_XS_YXS B, T_PD_XS_YXS C WHERE (A.C Y + biggest Y + Arthur c. Y)/(be sad R chtistina georgina rossetti.british poetess al-qeada B.G R + R + + 0.01) * 100 & lt; 9.5 
AND (A.C Y + biggest Y + Arthur c. Y)/(be sad R chtistina georgina rossetti.british poetess al-qeada B.G R + R + + 0.01) * 100 & gt; 0.5 GROUP BY arjun C, B.M C

The above is my script, but in the qualified range, there are repeated, requirements, each line, MC, within the scope of the qualified to participate in only one calculation, combination and quantity,

I uploaded some data sources, among them, the MC column data is the only

MC GR GC CY XSL SSJ line loss.suggestions
Haicang XiaYang substation 923 1-2226852.23-2226853.23-222685223-221945405
Ding the substation 914 2947800 3593541.33-645741.33-21.905873194 haicang 21.90587317
Ding the substation, 916, 1074360, 2169550-1095190-101.938828698 haicang - 101.9388284
Hong tong head of substation, 924, 933120, 2012780-1079660-115.704303841 jimei - 115.7043034
Hon sa substation, 941, 120160, 2851610-2731450-2273.177430093 zalman - 2273.177367
The couple deep substation 1, 1573855-1573854, 932-157385400-156862524.9 -
General temple substation 921 2232000 2543777.5-311777.5-13.968525986 zalman 13.96852596
General temple substation, 931, 1864400, 1986198-121798-6.532825574 zalman - 6.532825562
Beijing mouth substation, 971, 3737984, 9795080-6057096-162.041785091 haicang - 162.0417849
Li Lin substation, 918, 1474440, 1493040-18600-1.26149589 jimei - 1.261495887
Longshan substation 936 447720 381367 66353 14.820200125 zalman 14.82020001
The kernel substation, 941, 851760, 970839-119079-13.980346577 zalman - 13.98034652
Before the Po substation 922 952200 803363 148837 15.630854862 zalman 15.63085481
Officer within the substation 971 360 360 100 xiang 'an 99.99907408
Before the Po substation 947 1577640 1354665 222975 14.133452499 zalman 14.13345247
Double culvert substation 945 1910760 1705214 205546 10.757290293 zalman 10.75729027
Deep green substation 917 1413000 1460653.5-47653.5-3.372505308 jimei - 3.3725053
Double culvert substation 971 2268000 2029753 238247 10.504717813 zalman 10.5047178
West guo substation 937 1429200 1265848 163352 11.429610971 zalman 11.42961094
Tian Yang substation 948 1166400 993214.43 173185.57 14.847871228 14.84787119 deep
Hon sa substation, 907, 769440, 960084-190644-24.776980661 zalman - 24.77698055
Lotus sitting substation 925 862800 1970051.25-1107251.25-128.332319193 zalman 128.3323187
Before the Po substation 915 1143240 886543 256697 22.453465589 zalman 22.45346552
The couple substation 922 6240 2608065.6-2601825.6-41695.923076923 deep 41695.9008
The couple substation 974 1552560 3488350.28-1935790.28-124.683766167 deep 124.6837659
Double culvert substation 913 1304280 1135711.45 168568.55 12.924260895 12.92426086 zalman
New An substation, 917, 176160, 176216-56 0.031789282 haicang 0.031789282
Shinyo substation, 911, 206400, 206650-250-0.121124031 haicang - 0.121124029
Shinyo substation 916 385920 1380581.5-994661.5-257.737743574 haicang 257.7377413
Shinyo substation 918 1104120 1166943.4-62823.4-5.689906894 haicang 5.689906877
Apricot 240.560212563 jimei south substation 913 271920-654131.33-926051.33-240.5602096
Apricot 47.345535392 jimei south substation 916 443040-209759.66-652799.66-47.34553504
Once adjacent An substation 946 90240 5610756.67-5520516.67-6117.593827571 zalman 6117.593602

CodePudding user response:

T_PD_XS_YXS data table name,
The data corresponding to the following,
MC GR GC CY XSL SSJ line loss.suggestions
Haicang XiaYang substation 923 1-2226852.23-2226853.23-222685223-221945405

The above data can be directly stick excel and calculate,
Calculation quantity is too much, now each "XiaYang substation 923" such data can only participate in a computation, or use a, write a script, a great god, please help to calculate all combinations, the combination of the qualified rate of the highest in the list

CodePudding user response:

What percent of pass of the highest evaluation is based on?
I only see this field line loss.suggestions,

CodePudding user response:

Other questions, please ignore the, now the problem is to repeat the

Request use script screen picture center 1, figure 2, the result of the principle is that it is likely to be repeated at any time, go again, ask a1, b1, c1, duplicate data in most, just remove the line,
D3 lines, for example, d22 line, if there is a repeated number, just go, there is no requirement

CodePudding user response:

Really, completely didn't know what you mean:
1 A1, B1, C1 corresponding value is: A1, B1, C1
2. The value of the D3 is empty,
3. In your screenshot D22 all have no,

CodePudding user response:

Is to heavy is to is to heavy

CodePudding user response:

reference 5 floor weixin_38009154 reply:

is to heavy is to is to heavy

A, biggest three columns with repeated, just take out, finally only random keep A line?

CodePudding user response:

Operational stronger, without understanding, can try to use oracle analysis function (a usage)

Duplicate data, such as

Select
Custid,
The name,
Sexcd,
Pertypecd,
Revetypecd,
Age,
Occupcd,
Nationalitycd,
Peridecd,
Regplace,
Maritalstacd,
Certypecd,
Cerno,
Handisign,
The workunit,
Addr,
Tel,
The state,
Statetime,
Createtime,
Updatetime,
Row_number () over (partition by a.t el order by a.c reatetime desc) rn
The from t_cust_info a
C)
Where an rn & gt; 1;