title: Merging two Sql queries result side by side
body: <p>I have page_no and title as my columns , so i want all of the page_no even number title to be on left side and odd numbers to be on right side.</p>
  <p>This is how my data looks,</p>
  <pre><code>page_no title
  1       abc
  2       def
  3       ghi
  4       jkl
  6       mno
  </code></pre>
  <p>output</p>
  <pre><code>left_title  right_title
  Null        abc
  def         ghi
  jkl         null
  mno         null   
  </code></pre>
  <p>this is the query i had tried, i stuck on merging the two queries side by side.</p>
  <pre><code>with left_qry as
      (
      select 0 as page_no,Null as ttile
      union all
      SELECT * from recipes where cast(page_no as int) %2 = 0
      ),
      right_qry as
      (
      SELECT * from recipes where cast(page_no as int) %2 &lt;&gt; 0
      )
      -- here i am trying to merge left_qry and right_qry side by side
      select * from left_qry
      union 
      select * from right_qry;
  </code></pre>
  <p>can some one help me</p>