Page 1 of 1
to sort on row in asc and second row in desc in a table of 1
Posted: Thu Jul 16, 2009 11:26 pm
by 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
Posted: Thu Jul 16, 2009 11:29 pm
by 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
Posted: Thu Jul 16, 2009 11:38 pm
by 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
Posted: Thu Jul 16, 2009 11:41 pm
by 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.
Posted: Fri Jul 17, 2009 6:42 am
by 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.
