Select ID_Career, Bill_term_career From TableName Group by ID_Career Try this and see if it helps.. Let me know too. I will try other query's if this is not what you are looking for.