www.webdeveloper.com
Results 1 to 2 of 2

Thread: Select query

  1. #1
    Join Date
    Nov 2007
    Posts
    33

    Select query

    If in mysql database there's a column with some values that are repeating, for example group number for certain products, is it possible to select only the first product of each group? (if prodId 001, 002 and 003 have the same group 1, select only 001)

  2. #2
    Join Date
    Aug 2007
    Posts
    1
    select min(prodID)
    from product_groups
    group by groupID

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles