to sort on row in asc and second row in desc in a table of 1

[sunitha_cts]

Hi,

How can we sort the first row in asc and second row in desc in a table of ten columns.
Thanks
suniotha

[ray.wurlod]

No, simply because there's nothing that allows you to sort a row.

I assume you want a result something like

Code: Select all

 1  2  3  4  5  6
10  9  8  7  7  6
 3  5  9 11 13 20
15 14 12 10  9  5

[sunitha_cts]

HI,

EMPNO ENAME
70 AAA
10 BBB
30 ZZZ
.......UPTO 10 ROWS

70 AAA SHOULD BE IN ASC
10 BBB SHOULD BE IN DESC

Thanks
sunitha

[ray.wurlod]

You want to sort odd numbered rows and even numbered rows separately? Then separate them into two streams and sort them separately. Use a Funnel when re-assembling the rows into a single stream.

[chulett]

As noted, you don't "sort a row" so this makes absolutely no sense. Extend your example to all 10 rows and show 10 rows of output, maybe that will help explain what you are trying to say.