Delete comment from: Javarevisited
Your facts about the difference between "where" and "having" seem good, but the facts in your example are all messed up. The second table has the same data as the third table (and the second table has the highlighting that should have been in the third table), and the query it's associated with does not reflect the contents of the table, and the critical query that's supposed to demonstrate the "having" clause doesn't even have the "having" clause.
Aug 6, 2013, 5:46:03 PM
Posted to Difference between WHERE vs HAVING clause in SQL - GROUP BY Comparison with Example