Having used with aggregate function.
SELECT state, COUNT(*)
FROM Test
GROUP BY state
HAVING state IN ('CA', 'LA')
ORDER BY state
WHERE clause is used to impose condition on SELECT statement as well as single row function
SELECT cusnum, lstnam, init
FROM Test
WHERE state IN ('CA', 'LA')
Muhsinathk, if this helps please login to Mark As Answer. |
Reply | Alert Moderator