MySQL Forums
Forum List  »  Newbie

SQL Query help
Posted by: Robert Sullivan
Date: January 25, 2008 12:35PM

I do not know if this is in the right section but I need some direction. I have a db with a table with groups of IDs that point where this data groups to. IE

1 this goes with 1
1 me too
2 this goes with 2
2 2 here also

Along with the group ID there is a unique ID for each record. What I need to do is do a query to pull the lowest unique ID for each group ID along with a text field. Any help would be much appreciated.

Options: ReplyQuote

Written By
SQL Query help
January 25, 2008 12:35PM
January 25, 2008 01:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.