Results 1 to 3 of 3

Thread: Group by date

  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Group by date

    hello

    I have this table, with two columns, one contains email adresses and the other contains the date

    email date

    1@g.com date1
    3@g.com date1
    2@g.com date2

    I need a mysql query that outputs this:

    date1

    1@g.com
    3@g.com

    date2

    2@g.com

    thanks in advanced.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, that's a cosmetic re-arrangement of data which should be provided by a very straightforward and simple query

    do that in your application language, not in sql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2009
    Posts
    2
    thank you, Ill follow your advise and tell you later.

Posting Permissions

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