Filter results using WHERE and HAVING

suggest change

Syntax

SELECT column_name

FROM table_name

WHERE column_name operator value

SELECT column_name, aggregate_function(column_name)

FROM table_name

GROUP BY column_name

HAVING aggregate_function(column_name) operator value

Found a mistake? Have a question or improvement idea? Let me know.

Filter results using WHERE and HAVING:

* Filter results using WHERE and HAVING

* Use BETWEEN to Filter Results

* Use HAVING with Aggregate Functions

* WHERE clause with NULLNOT NULL values

* The WHERE clause only returns rows that match its criteria

* Equality

* AND and OR

* Use IN to return rows with a value contained in a list

* Use LIKE to find matching strings and substrings

* Use HAVING to check for multiple conditions in a group

* Where EXISTS

Table Of Contents

0 Getting started with SQL

1 SELECT

2 JOIN

3 Example Databases and Tables

4 UPDATE

5 Indexes

6 CREATE TABLE

7 UNION, UNION ALL

8 ALTER TABLE

9 CASE

10 INSERT

11 Primary Keys

12 ORDER BY

13 GROUP BY

14 Filter results using WHERE and HAVING

15 Window Fnctions

16 Common Table Expressions

17 Views

18 LIKE operator

19 Functions Aggregate

20 DELETE

21 String Functions

22 Data Types

23 AND OR operators

24 Triggers

25 TRUNCATE

26 MERGE

27 Foreign Keys

28 Finding Duplicates on a Column Subset with Detail

29 Sequence

30 Comments

31 Subqueries

32 Execution blocks

33 Stored Procedures

34 DROP Table

35 Row number

36 Transactions

37 CREATE FUNCTION

38 SQL Group by vs. Distinct

39 Table Design

40 CROSS APPLY and OUTER APPLY

41 Synonyms

42 CREATE database

43 SKIP TAKE pagination

44 EXPLAIN and DESCRIBE

45 Information Schema

46 IN clause

47 NULL

48 SQL Injection

49 Cascading Delete

50 Order of Execution

51 DROP or DELETE database

52 EXCEPT

53 TRYCATCH

54 XML

55 GRANT and REVOKE

56 Functions ScalarSingle Row

57 Relational Algebra

58 EXISTS CLAUSE

59 Materialized Views

60 Functions Analytic

61 SQL CURSOR

62 Identifier

63 Clean Code in SQL

64 Contributors