Use
DISTINCT
clause, which specifies that only unique rows can appear in the result set.
If you would like to count recipes, please try this:
SELECT RecipeName, Ingredient, Count(RecipeName) AS CountOfRecipes
FROM RecipeTable
GROUP BY RecipeName, Ingredient