WHERE Clause

  • The WHERE clause is used to extract only those records that fulfill a specified criterion.
    The WHERE clause is used to filter records.

    Eg.


    SELECT column_name,column_name
    FROM table_name
    WHERE column_name operator value;


    SELECT * FROM Customers
    WHERE Country='Mexico';


    Operator Description
    = Equal
    <> Not equal. Note: In some versions of SQL this operator may be written as !=
    > Greater than
    < Less than
    >= Greater than or equal
    <= Less than or equal
    BETWEEN Between an inclusive range
    LIKE Search for a pattern
    IN To specify multiple possible values for a column

  • Sorry No animation Yet.

    We are Working On this


OUR PARTNERS&Website builder — uCoz