title: Select top N columns based on standardized values
body: <p><a href="https://i.stack.imgur.com/gdjBT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gdjBT.png" alt="enter image description here"></a>Got a bit of googly question. Is it possible to select say  10 columns based on the values in each column if all the values are standardized.</p>
  
  <p>So for example</p>
  
  <pre><code>cluster Id | v1 | v2| v3 | v4 | v6 | v26 
  ___________________________________________
         1   | 4.2|0.9|05  |3.2 | 0.7|0.5
         2   | 1.2|0.1|0.9 |0.21|0.3 |0.1
  </code></pre>
  
  <p>so in this example if I wanted 3 top three columns for cluster 1  i'd have </p>
  
  <pre><code>     cluster ID |v1 |v4 |v2
              1   |4.2|3.2|0.9
  </code></pre>
  
  <p>I'm open to any suggestions at the moment i'm using Oracle Sql but wiling to switch if theres a solution on a different platform and its impossible using SQL</p>
  
  <p>edit. I've added an image which shows the feature i'm trying to replicate on Sql developer. The fetch size is the number of variables/attributes and there must be some table sitting behind the model that's being queried when I change the fetch size and thats the statement i'm trying to reproduce
  thank you</p>