title: Selecting the data from a table by grouping one column in Oracle
body: <p>I have a table <strong>T1</strong> as shown below  </p>
  
  <pre><code>ID PASSED   FAILED  PASSED_PERCENTAGE   FAILED_PERCENTAGE
  -- ------   ------  -----------------   -----------------
  1  380      172     50                  23 
  </code></pre>
  
  <p>I need a SQL query which gives me the output as below</p>
  
  <pre><code>DESC           ID        TOTAL         PERCENTAGE
  ----           --        -----         ----------
  PASSED         1         380           50
  FAILED         1         172           23
  </code></pre>
  
  <p><strong>Note:</strong> Table <strong>T1</strong> will always have only one row and the column <strong>ID</strong> will have constant value always as <strong>'1'</strong>
  Could anyone please help me with this. Many thanks in advance.</p>