Re: Sorting in a select - help!

Hi!

1)
select *
  from DTABLE
  where DTABLE.TOWN = QTOWN
order by decode (QSORT, 0, size_000_s, 1, date_000_d, date_000_d);

2) To reverse a sort:
...
order by size_000_s desc;

                     ^^^^

Nils wrote:
>
> I wish to make a select and have the data sorted, i.e.
>
> select * from DTABLE
> where
> (
> QTOWN = DTABLE.TOWN
> )
> order by size_000_s ;
>
> Questions: (to which, having consulted a couple of books,
> I cannot find a solution)
>
> (1) There are 3 different columns by which I could sort, i.e. size, date and so on - how can I do this - essentially I qould like to pass a parameter QSORT and then sort by size if it is 0, date if it is 1 and so on?
>
> (2) How can I reverse a sort - instead of the reault being sorted lowest to highest numeric value, I would like it sorted highest to lowest.
>
> Thanks,
>
> Nils
 

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.
e-mail: nec_at_leaves.spb.su