Databases
StackOverflow2013
Postsdbo
POHow to get alternate rows in MySQL based on some preferences?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get alternate rows in MySQL based on some preferences?
    text
    copied!<p>I have the following table - </p> <pre><code>S.No. (Auto Increment, Primary Key) Timestamp (Records date in yyyy-mm-dd format) type (Records the type of document Ex. 1,2,3,etc.) Number (Records the serial number of a particular type of document) </code></pre> <p>Now I want to generate a table where I want to order data by timestamp. Based on <code>type</code> I want to display some columns to the left side and some to the right side of the report. So, I want to order my result set to be first ordered by timestamp and then order by type. Say I want 1,2,3 on the left side and 4,5,6 on the right side. So what I want in my resultset is there must be alternate rows of left and right side. Ex. </p> <pre><code>Timestamp Type 2012-01-01 1 2012-01-01 4 2012-01-01 1 2012-01-01 4 2012-01-01 1 2012-01-01 5 2012-01-01 1 2012-01-01 6 2012-01-01 2 2012-01-01 2 2012-01-01 2 </code></pre> <p>I tried to do this but didn't get the desired result. This is the final result I want -</p> <p>Timestamp &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Timestamp &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type <br> 2012-01-01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br> 2012-01-01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<br> 2012-01-01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 <br> 2012-01-02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6<br> 2012-01-02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2012-01-03 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-03 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2012-01-03 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5<br></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload