Re: Multiple column sorting with a decode

Thank you for your answer.
You are right, I did not express myself correctly.

In my example I used column numbers to write the question more quickly,
but even using column names, it still has the exact same result.

Column 1 is not a constant, I simply used it as an example. What I am
trying to do is provide the user excuting the report a choice on the
multiple ordering. If :param =1 for example, then the sorting will be
on 3 of the columns and if param = 2 on 4 (different) columns (for
example).

What might work is this: ORDER BY DECODE(...), DECODE(...), DECODE(...)
providing I can fill the unused ones with something that does not
change the result.

Once again, thanks for your answer.

.

Relevant Pages

  • RE: Formula Help with Lists
    ... >> I need to be able to pull a list from series of data without sorting or ... >> John in A8? ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Adding tables
    ... I'm using a query to add a table to another table, ... with the sorting ... Gertjan ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Removed a field from table - now form prompts for the field?
    ... Is it in your sorting? ... > Now when I open the form, I get a prompt for the field. ... > Cancel, it goes on to open the form. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Deleting entire rows when several cells match
    ... Hey Folks, ... After sorting them by a few columns, I end up with around 6,000 more rows ... Steve ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Interoping h files
    ... public static extern void foo (unsigned int & param); ... Strange, isn't it? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
Loading