title: sql select display row data as columns
body: <p>I have a sql select query that extracts result as:</p>
  
  <pre><code>login_count  login_type
  2000         iPhone
  7000         browser 
  </code></pre>
  
  <p>But i want the result as:</p>
  
  <pre><code>iphone_login  browser_login
  2000          7000
  </code></pre>
  
  <p>i.e. i want to extract row1-col1 as col1 and row2-col2 as col2 using a select query.    </p>
  
  <p>My original query is</p>
  
  <pre><code>select count(login_count), login_type from log_table group by login_type;
  </code></pre>
  
  <p>Thanks,
  Gaurav</p>