Open links in new tab
  1. 123

    The WHERE clause in SQL is used to filter records based on specified conditions. It allows you to retrieve, update, or delete only those records that meet the criteria.

    Example

    To select all customers from Mexico:

    SELECT * FROM Customers
    WHERE Country = 'Mexico';
    Copied!

    Syntax

    SELECT column1, column2,
    FROM table_name
    WHERE condition;
    Copied!

    Operators in WHERE Clause

    You can use various operators in the WHERE clause to filter data:

    • =: Equal to

    • >: Greater than

    • <: Less than

    • >=: Greater than or equal to

    • <=: Less than or equal to

    • <> or !=: Not equal to

    • BETWEEN: Between a certain range

    • LIKE: Search for a pattern

    • IN: Specify multiple possible values for a column.

    Example with Multiple Conditions

    To select all offices in the USA with office codes greater than 5:

    SELECT * FROM offices
    WHERE country = 'USA' AND office_code > 5;
    Copied!

    Using IN Operator

    To select cities and countries of offices in the UK or France:

    SELECT city, country
    FROM offices
    WHERE country IN ('UK', 'France');
    Copied!

    The WHERE clause is essential for targeting specific rows in SELECT, UPDATE, or DELETE operations. It is crucial for efficient data manipulation and retrieval.

    Learn more:
    1 -w3schools.com2 -learnsql.com3 -learnsql.com
    How to Write a WHERE Clause in SQL - LearnS…

    This article covers how to use the SQL WHERE clause in detail, with practical examples usin…

    LearnSQL.com
    Why should you use SQL 'where'?
    Navigating through vast databases can feel like searching for a needle in a haystack. That’s where SQL’s WHERE clause becomes a game-changer. It’s my go-to tool for filtering data, ensuring I get exactly what I need without sifting through irrelevant information.
    sql-easy.com
    SQL Easy
    https://www.sql-easy.com/learn/how-to-use-where-in-sql
    How to Use WHERE in SQL with Examples
  1. W3School
    https://www.w3schools.com › SQL › sql_where.asp

    SQL WHERE Clause - W3Schools

    The WHEREclause is used to filter records. It is used to extract only those records that fulfill a specified condition.
    Text Fields vs. Numeric Fields

    SQL requires single quotes around text values (most database systems will also allow double quotes). However, numeric fields should not be enclosed in quotes:

  2. LearnSQL.com
    https://learnsql.com › blog › where-clause-in-sql

    How to Write a WHERE Clause in SQL - LearnSQL.com

    Nov 9, 2021 · This article covers how to use the SQL WHERE clause in detail, with practical examples using sample data sets.

  4. GeeksForGeeks
    https://www.geeksforgeeks.org › sql › sql-where-clause

    SQL - WHERE Clause - GeeksforGeeks

    Nov 12, 2025 · The SQL WHERE clause filters rows based on one or more conditions, so your query returns (or modifies) only the records that match. It’s used across SELECT, UPDATE, and DELETE …

  5. SQL Easy
    https://www.sql-easy.com › learn › how-to-use-where-in-sql

    How to Use WHERE in SQL with Examples

    Mar 3, 2024 · Understanding the WHERE clause is crucial for anyone looking to harness the full power of SQL. Whether you’re a beginner or looking to brush up on your skills, I’ll guide you through the ins and …

  6. TechOnTheNet
    https://www.techonthenet.com › sql › where.php

    SQL: WHERE Clause - TechOnTheNet

    This SQL tutorial explains how to use the SQL WHERE clause with syntax and examples. The SQL WHERE clause is used to filter the results and apply conditions in a SELECT, INSERT, UPDATE, or …

  8. Microsoft Learn
    https://learn.microsoft.com › en-us › sql › t-sql › queries › where-transact-sql

    WHERE (Transact-SQL) - SQL Server | Microsoft Learn

    Nov 18, 2025 · Defines the condition to be met for the rows to be returned. There's no limit to the number of predicates that can be included in a search condition. For more information about search …

  9. SQL Server Tutorial
    https://www.sqlservertutorial.net › sql-server...

    SQL Server WHERE Clause

    Summary: in this tutorial, you will learn how to use the SQL Server WHERE clause to filter rows returned by a query. The SELECT statement retrieves all rows from a …

  10. TutorialsPoint
    https://www.tutorialspoint.com › sql › sql-where-clause

    SQL - WHERE Clause - Online Tutorials Library

    The SQL WHERE clause is used to filter records based on specific conditions. It ensures that only the rows meeting the given criteria are affected or returned by a SELECT, UPDATE, or DELETE statement.

  11. Tutorial Gateway
    https://www.tutorialgateway.org › sql-where-clause

    SQL WHERE Clause - Tutorial Gateway

    We can use the WHERE clause in UPDATE and DELETE statements. In fact, we must not use those statements (UPDATE and DELETE) without the WHERE clause. …

  12. DataLemur
    https://datalemur.com › sql-tutorial › sql-where

    SQL WHERE [SQL Tutorial with Examples] - DataLemur

    Learn to use the SQL WHERE clause to filter data, so that we only SELECT rows that meet certain conditions.

Content was generated with AI. Learn more