We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!
... HAVING sql_cond ...
The addition HAVING limits the number of rows in groups in the result set of a query by using the logical expression sql_cond on these rows. The logical expression evaluates the content of row groups. Those rows are placed in the result set for which the logical expression is true.
The following applies to the operands of the relational expressions of the logical expression sql_cond:
If a HAVING clause is specified, all columns in the SELECT list that are not arguments of aggregate expressions here must be specified after GROUP BY. If the SELECT list is specified as *, HAVING clauses without GROUP BY clauses cannot be used.
Implicit client handling applies to the HAVING clause. The client column of a client-dependent data source cannot be used as an operand in the HAVING condition.
Reading of the number of bookings in each class and for each flight date of a connection.
SQL Expressions, Use in Aggregate Expressions