Posted by Artek Siara on 06/16/05 13:49

I have a table with one column, for example:
1
2
3
4
5

I need to make a query which return a table with two column, for example 'a'
and 'b', and column
'a' contains all rows from the table except the last, and column 'b'
contains all rows from the table except the first.
How can I do it using one query ?
The result should look like:
a | b
1 | 2
2 | 3
3 | 4
4 | 5

thanks for help

[Back to original message]