Oracle SQL: getting all row maximum number from specific multiple criteria -

-

मेरे पास निम्न तालिका नाम है foo: 

  आईडी | डी 1 | डी 2 | डी 3 | --------------------- 1 | 47 | 3 | 71 | 2 | 47 | 98 | 82 | 3 | 0 | 99 | 3 | 4 | 3 | 100 | 6 | 5 | 48 | 10 | 3 | 6 | 49 | 12 | 4 |

मैं एक चुनिंदा क्वेरी चलाऊंगा और परिणाम इस तरह दिखेंगे 

  आईडी | डी 1 | डी 2 | डी 3 | परिणाम | ------------------------------ 1 | 47 | 3 | 71 | डी 3 | 2 | 47 | 98 | 82 | डी 2 | 3 | 0 | 99 | 3 | डी 2 | 4 | 3 | 100 | 6 | डी 2 | 5 | 48 | 10 | 3 | डी 1 | 6 | 49 | 12 | 4 | डी 1 |

अतः, मूलतः मुझे डी 1, डी 2, डी 3 कॉलम के बीच अधिकतम मूल्य प्राप्त करना चाहते हैं I जैसा कि आप देख सकते हैं, डीडी 1: डी 2: डी 2: डी 3: डी 3

के बीच अधिकतम मान से आईडी 1 के पास D3 है, इसका अर्थ है 4: 3: 71, मैक्स वैल्यू 71 है। यही वजह है कि परिणाम 'डी 3'

"पोस्ट-पाठ" itemprop =

"पाठ">

निम्नलिखित पर विचार करें - एक सामान्यीकृत दृष्टिकोण ... 

  ड्रॉप तालिका यदि मेरे_एबल मौजूद है; टेबल बनाओ my_table (आईडी INT नहीं NULL, डी INT नहीं शून्य, वैल INT नहीं शून्य, प्राथमिक कुंजी (आईडी, डी)); My_table VALUES (1,1, 47), (2,1, 47), (3,1,0), (4,1,3), (5,1,48), (6,1, 4 9) में सम्मिलित करें ), (1,2,3), (2,2, 9 8), (3, 2 99), (4,2, 100), (5,2, 10), (6,2, 12), (1 , 3, 71), (2,3,82), (3,3,3), (4,3,6), (5,3,3), (6,3,4); SELECT * my_table से; + ---- + --- + ----- + | आईडी | डी | वैल | + ---- + --- + ----- + | 1 | 1 | 47 | | 1 | 2 | 3 | | 1 | 3 | 71 | | 2 | 1 | 47 | | 2 | 2 | 98 | | 2 | 3 | 82 | | 3 | 1 | 0 | | 3 | 2 | 99 | | 3 | 3 | 3 | | 4 | 1 | 3 | | 4 | 2 | 100 | | 4 | 3 | 6 | | 5 | 1 | 48 | | 5 | 2 | 10 | | 5 | 3 | 3 | | 6 | 1 | 49 | | 6 | 2 | 12 | | 6 | 3 | 4 | + ---- + --- + ----- + SELECT x। * My_table x से (चयन आईडी, अधिकतम (वैल) max_val fROM my_table ग्रुप द्वारा आईडी) y पर y.id = x.id और y .max_val = x.val; + ---- + --- + ----- + | आईडी | डी | वैल | + ---- + --- + ----- + | 1 | 3 | 71 | | 2 | 2 | 98 | | 3 | 2 | 99 | | 4 | 2 | 100 | | 5 | 1 | 48 | | 6 | 1 | 49 | + ---- + --- + ----- +

(यह एक MySQL समाधान के रूप में किया गया है - मैं ओरेकल वाक्यविन्यास से परिचित नहीं हूँ, इसलिए अगर यह नहीं 'टी पोर्ट)

क्या यह आपकी टिप्पणी का जवाब है? 

  SELECT x। *, Y.max_val my_table x से जुड़ें (SELECT id, MAX (val) max_val fROM my_table ग्रुप द्वारा आईडी) y पर y.id = x.id; + ---- + --- + ----- + --------- + | आईडी | डी | वैल | अधिकतम_वल | + ---- + --- + ----- + --------- + | 1 | 1 | 47 | 71 | | 1 | 2 | 3 | 71 | | 1 | 3 | 71 | 71 | | 2 | 1 | 47 | 98 | | 2 | 2 | 98 | 98 | | 2 | 3 | 82 | 98 | | 3 | 1 | 0 | 99 | | 3 | 2 | 99 | 99 | | 3 | 3 | 3 | 99 | | 4 | 1 | 3 | 100 | | 4 | 2 | 100 | 100 | | 4 | 3 | 6 | 100 | | 5 | 1 | 48 | 48 | | 5 | 2 | 10 | 48 | | 5 | 3 | 3 | 48 | | 6 | 1 | 49 | 49 | | 6 | 2 | 12 | 49 | | 6 | 3 | 4 | 49 | + ---- + --- + ----- + --------- +

Comments

Post a Comment

Popular posts from this blog

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel -

-
Image
I have a requirement whenever I run my own kettle, dynamically took database connection parameters from an excel source Every run should go. I have an Excel column names: hostname, username, database, password. I want to pass these connection parameters to my table input stage dynamically whenever it runs the job. This is what I was trying to do. You can get it Connection parameters from the DB reading source (for example Excel or a CSV file in my example) < / Li> Store the parameters in the variable Using the variable in your connection's settings. Setting Variables Create another conversion for (you can not do it in the same conversion Uses): set variables element variable: The element that reads / writes your data creates a new connection and sets the connection parameter using $ {variable name_} Note that you will need to type in the field field in the field $ {password} Also keep in mind that this can be a security problem as the
Read more

multithreading - PhantomJS-Node in a for Loop -

-
I am trying to implement a screen-scraps application that opens a URL in which a parameter changes as it is for a loop: var data = [ '100', '101', '102', '103', '104']; (Var indexA = 0; indexA & lt; data.length; indexA ++) for {Phantom Generation ({'port': freeport}, function (pH) {ph.create page (function (page) {page.open ("http: //...++ data [index B] +" ... " , Status {console.log ("open site:" + data [index B], position); / * OLD * / indexB ++; page evaluation (function () {// page scrape and an object Return}, function {console.log (result.dataRequest); // here is the problem}); / * new and fixed * / indexB ++} first console Logs it: Open Site: 100 Success Opens Site: 101 Success B Ola Site: 102 Success Opening Site: 103 Success Opened Site: 104 Success Which is good. Data is verified in scrap HTML and from index to array Matches. So in page 101 I scrap '101 and retrieve' and pu
Read more

c++ - MATLAB .m file to .mex file using Matlab Compiler -

-
I know that it can speak as a very famous topic, but something that helps me with it Not found This scenario is: I have my functions function, no matter what's inside, it's a generic function that may depend on other toolboxes. Does. Has input and output; I want to generate the same myFun.mex function; : Lib myFun This way I get some new files: libmyfun.c libmyfun.dll Libmyfun.exp libmyfun.exports libmyfun .h libmyfun.lib Reading around and I think that Creating a myfun.cpp that is very famous is included: / * gateway function * / zero max function (ent NLHS, MXARRA * PLS [], int NRHS, CONST M Xeray * PHS []) Here is the Variable Deals * / / * code here * /} I have tried to do this and are called Regular of Max Generation: Max ('- v', 'myfun.cpp') But I get many errors, and I should say that my myfun.cpp copy / Paste Function is where I have a lot of doubts ... especially on input / output management. My q
Read more