Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Red face Unanswered: Group the sql table

    Posted - 04/02/2010 : 04:00:14
    --------------------------------------------------------------------------------

    i have the following sql table:
    studid studname Assname Marks
    1234567 alice test 1 30
    1234567 alice test 2 30
    8900122 bob test 1 29
    8900122 bob test 2 30

    i would like to grop the table to look like this
    studid studname Assname Marks
    1234567 alice test 1 30
    test 2 30
    8900122 bob test 1 29
    test 2 29


  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by aim View Post
    i would like to grop the table to look like this
    Code:
    studid    studname  Assname  Marks
    1234567   alice     test 1    30
                        test 2    30
    8900122   bob       test 1    29
                        test 2    29
    "eek" () is right

    this should not be done with SQL

    do it in your front-end application program
    rudy.ca | @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
  •