Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: automatic order by with group by

    In 8i the result set of a query with a group by statement was automatically ordered by the group by columns. This does not seem to be the case in 9i. Is there a way in 9i to force this to happen ?

    Thanks in advance

  2. #2
    Join Date
    Apr 2004
    Posts
    246
    it was never a supported/documented feature - in any version. the group by just "tended" to result in an order by that was the same. even in 9, it still tends to order the same as the group by, but it is not guaranteed. only way is to use the order by explicitly
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •