SQLitening Support Forum

I'm not sure if this is possible or not, but thought I'd ask the SQL/SQLite gurus here...

I've got a table that includes two columns A and B filled with integer values like so (in ascending order on Column A):

Column A	Column B
1	2
2	25
3	4
4	26
5	6
...	...
25	3
26	5
...	...

I'd like to retrieve records from the table sorted by the minimum value across both columns A and B with column B taking precedence.  Like so:

Column A	Column B
1	2
2	25
25	3
3	4
4	26
26	5
5	6
...	...

It doesn't look like the ORDER BY clause in a SELECT statement gives me any means to achieve this.  Or does it?  Any other elegant solution available?

Have you tried "Select * from Table Order by ColumnB || ColumnA"

I tested just now.  Unfortunately, that concatenates the values in the two columns as strings and then does a string sort/order on the result.  It did not produce the desired results.

I may have a solution involving a new column and a couple of triggers, but I haven't tested it yet, so I won't post it here for now.  If it works, I will explain what I did.

"SELECT * FROM table ORDER BY MIN( ColumnA + 0.5, ColumnB)" works. 

My new column and trigger solution also works and is essentially the same thing as the above, but retains the MIN( ColumnA + 0.5, ColumnB) value for each record in the new column so the select statement doesn't have to do the processing.