flipping ordering of returned query results

2016-01-30 Thread Jan
Folks;  Need some advice. We have a time-series application that needs the data being returned from C*     to be flipped from the typical column based data to be row based.  example :  C*    data :   A   B  C                     D  E  F  need returned data to be :                          A  D  

Re: flipping ordering of returned query results

2016-01-30 Thread Jack Krupansky
Could you clarify... is this for pairs of rows, or is it n rows with n columns, and is n a constant known before the query executes or based on the presence of non-NULL column values? And is this always adjacent rows using a clustering key - as opposed to a partition key which does not guarantee