Method to Count Number of Returned Rows 1

[Signit]

The following query returns 4 rows of data. I would like to write a query that will count those rows. ie if 4 rows are returned I want to simply have a single row that says 4. Would this require a view? Thanks for your help in advance!

SELECT recipeID, count(ingredientID) AS N
FROM recipeIngredients
WHERE (ingredientID='ing011' OR ingredientID='ing015' OR ingredientID='ing032')
GROUP BY recipeID;

 

[PHV]

Something like this ?
SELECT COUNT(DISTINCT recipeID) AS NRows
FROM recipeIngredients
WHERE (ingredientID='ing011' OR ingredientID='ing015' OR ingredientID='ing032');

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884