Question
Which SQL clause is used to filter groups after
aggregation (i.e., having aggregated value conditions)?Solution
HAVING filters groups based on aggregate functions; WHERE filters rows before grouping.
More SQL Questions
Find the missing number in the given number series.
1, 2, 6, 24, 120, ?140, 146, 158, 176, ?, 230
7, 6, 10, 27, 104, ?Â
What will come in place of the question mark (?) in the following series?
11, 13, 19, ?, 51, 81
48, 95, 283, 1129, ?, 33841
22, 37, 63, 98, 148, ?
12, 19, 32, ?, 76, 107
What will come in place of the question mark (?) in the following series?
130, 158, 214, 298, ?, 550
45, 58, 84, 123, ?, 240Â
What will come in place of the question mark (?) in the following series?
4, 11, 32, 95, 284, 851, ?
