---
title: "HAVING Clause"
url: https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/having/
description: "ZCQL is Catalyst's own query language modelled after familiar query languages that you can use to query your app's database efficiently."
last_updated: 2026-08-28T06:26:16Z
service: Cloud Scale
type: general
---

# HAVING Clause

### Introduction

The `HAVING` clause is used to select data records based on a specified condition. You can also apply [ZCQL functions](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/zcql-functions/) in the query using this clause. The `HAVING` clause can only be used with [`SELECT`](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/select/) queries.

The syntax for using the `HAVING` clause is shown below:

```sql
SELECT column_name FROM base_table_name GROUP BY column_name HAVING column_name OPERATOR condition
```

### Operators Supported by the HAVING Clause

You can use the following operators in the `HAVING` conditions in ZCQL `SELECT` queries:

<table class="content-table">
	<thead>
		<tr>
			<th class="w25p">Operators</th>
			<th class="w75p">Description</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>=</td>
			<td>Equal to</td>
		</tr>
        <tr>
			<td>IS</td>
			<td>TRUE if the operand is the same as the value</td>
		</tr>
        <tr>
			<td>IS NULL</td>
			<td>TRUE if the operand is a null value</td>
		</tr>
        <tr>
			<td>IS NOT NULL</td>
			<td>TRUE if the operand is not a null value</td>
		</tr>
        <tr>
			<td>=!</td>
			<td>Not equal to</td>
		</tr>
        <tr>
			<td>LIKE</td>
			<td>TRUE if the operand matches a pattern</td>
		</tr>
        <tr>
			<td>NOT LIKE</td>
			<td>TRUE if the operand does not match a pattern</td>
		</tr>
        <tr>
			<td>BETWEEN</td>
			<td>TRUE if the operand value is between the start and end values</td>
		</tr>
        <tr>
			<td>IN</td>
			<td>TRUE if the operand is equal to a list of expressions</td>
		</tr>
        <tr>
			<td>NOT IN</td>
			<td>TRUE if the operand is not equal to a list of expressions</td>
		</tr>
        <tr>
			<td>&gt;</td>
			<td>Greater than</td>
		</tr>
        <tr>
			<td>&gt;=</td>
			<td>Greater than or equal to</td>
		</tr>
        <tr>
			<td>&lt;</td>
			<td>Lesser than</td>
		</tr>
        <tr>
			<td>&lt;=</td>
			<td>Lesser than or equal to</td>
		</tr>
	</tbody>
</table>

### ZCQL Functions with HAVING Clause

[ZCQL functions](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/zcql-functions/) like `SUM()`, `COUNT()`, `AVG()`, etc., can be used with the `HAVING` clause in a `SELECT` query.

**Example Database**:

The employee details of Zylker Technologies are being maintained in the [Data Store](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/introduction/) in the *Zylker_Employee_DB* table. The table contains the following columns and rows:

<table class="content-table">
	<thead>
		<tr>
			<th class="w15p">ID</th>
			<th class="w30p">Name</th>
			<th class="w30p">Department</th>
            <th class="w25p">Salary</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>ZT-001</td>
			<td>Amelia Burrows</td>
			<td>Product Management</td>
            <td>15000</td>
		</tr>
		<tr>
			<td>ZT-2001</td>
			<td>Bruce Wayne</td>
			<td>Sr. Management</td>
            <td>85000</td>
		</tr>
		<tr>
			<td>ZT-239</td>
			<td>Clark Kane</td>
			<td>Media Relations</td>
            <td>85000</td>
		</tr>
		<tr>
			<td>ZT-4289</td>
			<td>Michelle Mascarenhas</td>
			<td>Finance</td>
            <td>89000</td>
		</tr>
	</tbody>
</table>

Let's use the [`AVG()`](https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/zcql-functions/#avg) ZCQL function, with the `HAVING` clause in an example `SELECT` query. 

```sql
SELECT Name, Department, Salary FROM Zylker_Employee_DB GROUP BY Department HAVING AVG(Salary) > 50000
```

<table class="content-table">
	<thead>
		<tr>
			<th class="w30p">Zylker_Employee_DB.Salary</th>
			<th class="w35p">Zylker_Employee_DB.Department</th>
			<th class="w35p">Zylker_Employee_DB.Name</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>85000</td>
			<td>Sr. Management</td>
			<td>Bruce Wayne</td>
		</tr>
		<tr>
			<td>89000</td>
			<td>Finance</td>
			<td>Michelle Mascarenhas</td>
		</tr>
	</tbody>
</table>

> **Note:** 

* This functionality is only available in **ZCQL V2**.

* From **December 01st, 2024**, all your current projects in all your [Orgs](https://docs.catalyst.zoho.com/en/getting-started/catalyst-organizations/) present in the [Development Environment](https://docs.catalyst.zoho.com/en/deployment-and-billing/environments/development-environment/) will be automatically mapped to **ZCQL V2 Parser**.

* From **April 01st, 2025**, all the projects present in all *Orgs* that have already been mapped to **ZCQL V2 Parser** in *Development Environment* will be automatically mapped to **ZCQL V2 Parser** in the [Production Environment](https://docs.catalyst.zoho.com/en/deployment-and-billing/environments/production-environment/), if and when production is enabled for the project.