SQL WHERE Clause | Querying Data from Single Table

SQL WHERE Clause: Where clause is used to filter data based on conditions and we have different ways to do that, below you can find the options on how to do that with simple examples.

SQL WHERE Clause

We have multiple options to use in SQL Where clause a multiple way specifies the comparison operators to get the data based on operations. Follow the below sample examples for more information. Click Here!

1. We can use comparison operator with where clause like (=, >, >=, <, <=, !=, <>). Note: Not equal to can be used in 2-ways (!= or <>).

2. Always use string (basically text) with in double quote and single quote (“” or). Same applies to date as well.

SELECT *
FROM customers
WHERE points = 3000;
SQL WHERE Clause
SELECT *
FROM customers
WHERE state >= 'VA';
SQL WHERE Clause
SELECT *
FROM customers
WHERE birth_date <> '1990-01-28';
SQL WHERE Clause

Watch Video!

Next Post>> #2.4) AND, OR, NOT (Single Table)

<< Previous Post #2.2) Select Clause (Single Table)

Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *