Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    Unanswered: Selection Problem

    I have a table as follow:

    Name Cuntr. Mon. Major Year
    Peter Canda Jan Sci 2004
    Peter Canda Feb Sci 2004
    Johin China Jan Art 2004
    Johin China Jan Art 2005
    Maria Italy Jan Art 2004
    Londi Italy Feb Sci 2005
    Londi Italy Mar Sci 2005

    My objective is to extrct part of the table so that the output cannot have a record that only has different in Month. i.e. the result should be:

    Name Country Month Major Year
    Pete Canda Jan Sci 2004
    John China Jan Art 2004
    John China Jan Art 2005
    Mary Italy Jan Art 2004
    Lond Italy Feb Sci 2005

    How can I input the SQL in order to achieve this target?

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    select Name, Country, min(Month), Major, Year
    from yourtable
    group by Name, Country, Major, Year | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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