SQL query to print mirror labels

Posted by Eric on Stack Overflow See other posts from Stack Overflow or by Eric
Published on 2012-07-07T01:51:43Z Indexed on 2012/07/09 21:15 UTC
Read the original article Hit count: 236

Filed under:
|

I want to print labels in words as returned by a SQL query such as follow.

1 2 3
4 5 6

When I want to print the reverse of those labels, I have to print them as follow

3 2 1
6 5 4

In my real case, I have 5 colums by 2 rows, how can I formulate my query so that my records are ordered like the second one. The normal ordering is handled by word, so my query is like

SELECT * FROM Products ORDER BY Products.id

I'm using MS Access =(

EDIT :

Just to make it clear

I'd like my records to be ordered such as

3 2 1 6 5 4 9 8 7 12 11 10

EDIT2 :

my table looks like this

ID    ProductName
1     Product1
2     Product2
3     Product3
n     Product[n]

I want the ids to be returned as I mentioned above

© Stack Overflow or respective owner

Related posts about sql

Related posts about ms-access