A table has a sort field col1, field type for int, is it possible that the script implement the following sort


When the query number is within 6
1 3 5 - & gt;
- & gt; 2 4 6

When the query sequence number is less than 9
1 4-7 & gt;
---> 2 5-8 & gt;
---> 3 6 9

When the query sequence number is less than 12
1 9-5 & gt;
---> 2 6-10 & gt;
---> 3 July 11 - & gt;
---> 4 August 12

So on the

CodePudding user response:

This kind of special request should be done by reporting tools, side laboured in oracle

CodePudding user response:

Can use stored procedures to implement, the query statements directly to write dead, want again to modify the logic, it is a nuisance

CodePudding user response:

The order by the mod (col1, 3), col1

CodePudding user response:

This is what ah, this is a two dimensional array, look not to understand

CodePudding user response:

This field is ordered