Professional Web Applications Themes

conditional group by? - MySQL

Say I have a table like this: customer_number | name I'd like to do a group by the customer_number unless the customer_number is negative, at which point, I'd like to group by name. Unfortunately, I'm not really sure how to do that. Any ideas?...

  1. #1

    Default conditional group by?

    Say I have a table like this:

    customer_number | name

    I'd like to do a group by the customer_number unless the
    customer_number is negative, at which point, I'd like to group by name.

    Unfortunately, I'm not really sure how to do that. Any ideas?

    yawnmoth Guest

  2. #2

    Default Re: conditional group by?

    >Say I have a table like this: 

    Write an expression that returns the customer_number unless the
    customer_number is negative, in which case, it returns the name.
    Hint: if()

    Now group by that.
    Gordon Guest

  3. #3

    Default Re: conditional group by?

    yawnmoth wrote: 

    Either like Gordon said or UNION 2 queries, one of which deals with the
    negative customer numbers and the other which deals with the rest


    Paul Guest

Similar Threads

  1. Conditional compile if 64-bit cpu, in .xs ?
    By Peter in forum PERL Modules
    Replies: 6
    Last Post: August 29th, 09:23 AM
  2. May 29 Sydney Developers Group study group
    By 105 in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 25th, 02:56 PM
  3. Conditional sum?
    By Fred in forum FileMaker
    Replies: 2
    Last Post: October 28th, 04:16 PM
  4. Conditional Value Lists
    By Jean Biver in forum FileMaker
    Replies: 2
    Last Post: August 21st, 11:43 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139