T-SQL Documentation - Having

Introduction

This section provides an overview of the T-SQL language and the ‘having’ clause.

The ‘having’ clause is used to filter results based on a condition.

The ‘Having’ Clause

The ‘having’ clause is used to filter results of a query.

It allows you to add conditions to a result set.

Example

Consider a query:

• SELECT * FROM employees WHERE salary > 50000;

The 'having' clause could be used to filter the results to only include employees with a salary greater than 50000.

More Examples

Here are a few more examples:

• SELECT * FROM products WHERE price < 100;
• SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

Link to Documentation

For more details, refer to the official T-SQL documentation: https://learn.microsoft.com/en-us/sql/t-sql

Sidebar

A short sidebar to provide context.