Professional Web Applications Themes

Grouping Unions - MySQL

Hi, is there a possibility (in MySQL > 4.1) to GROUP BY the result of an ONION? Simply using (SELECT ...) UNION (SELECT ...) GROUP BY ... is not possible, but can it be rewritten? Regards, André...

  1. #1

    Default Grouping Unions

    Hi,

    is there a possibility (in MySQL > 4.1) to GROUP BY the result of an ONION?
    Simply using (SELECT ...) UNION (SELECT ...) GROUP BY ... is not possible,
    but can it be rewritten?

    Regards,
    André


    André Hänsel Guest

  2. #2

    Default Re: Grouping Unions

    André Hänsel wrote:
    > is there a possibility (in MySQL > 4.1) to GROUP BY the result of an
    > ONION?
    Of course I meant "UNION", but it's probably an interesting question if one
    can group by the result of an onion. ;)


    André Hänsel Guest

  3. #3

    Default Re: Grouping Unions

    André Hänsel wrote:
    > Hi,
    >
    > is there a possibility (in MySQL > 4.1) to GROUP BY the result of an ONION?
    > Simply using (SELECT ...) UNION (SELECT ...) GROUP BY ... is not possible,
    > but can it be rewritten?
    >
    > Regards,
    > André
    >
    >
    I don't know about Onions, but for Unions, sure you can:

    SELECT
    textxcol, SUM(numcol)
    FROM
    (
    select textcol,numcol from table1 where whatever
    union
    select textcol,numcol from table2 where whatever else
    ) as t
    GROUP BY
    textcol

    ciao
    gmax

    --
    _ _ _ _
    (_|| | |(_|>< The Data Charmer
    _|
    [url]http://datacharmer.blogspot.com/[/url]
    Giuseppe Maxia Guest

Similar Threads

  1. Visual Query Builder with unions and sub-queries
    By sales@activedbsoft.com in forum MySQL
    Replies: 0
    Last Post: December 27th, 11:49 AM
  2. help with grouping
    By rere in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: July 21st, 08:41 PM
  3. Grouping
    By SRam in forum Informix
    Replies: 2
    Last Post: August 28th, 02:54 PM
  4. Parallel SELECT for UNIONs
    By Billy Verreynne in forum Oracle Server
    Replies: 0
    Last Post: December 23rd, 06:00 AM

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