locked
Rollup RRS feed

  • Question

  • Hi,

    I have a table in a particular order which I ned to maintain.when I say select a,b, from tab group by a,b,c with rollup the order of the output is changed.How can I avoid this.

    thanks,
    ssm
    Thursday, June 30, 2005 8:01 PM

Answers

  • GROUPING and ROLLUP may not preserve order.  You will need to add an ORDER BY clause to your query.

    Thursday, June 30, 2005 9:51 PM