Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: group by all except one

    Hello,
    i want to ask whether exist some possibility to make sql query grouping all fields except one field. Because is annoying when you must make select something like:

    SELECT a,b,c,d,e,count(f) FROM x GROUP BY a,b,c,d,e

    when easiest way is something like.

    SELECT a,b,c,d,e,count(f) from x GROUP BY ALL except f.


    Is something like 'except' operator possible? and in other databases?


    Thank you

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No.

Posting Permissions

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