When retrieving data from a single table or by joining data from multiple tables, a condition is specified using the SQL WHERE clause. If the given condition is satisfied, then only it returns a specific value from the table. The WHERE clause should be used to filter the records and only retrieve those that are required.
Syntax:
SELECT column_names
FROM table_name
WHERE conditions;
The SELECT
clause specifies the columns to be returned from the table(s), the WHERE
clause contains the conditions that must evaluate to true for a row to be returned as a result.
Operator | Description |
---|---|
> | Greater Than |
>= | Greater than or Equal to |
< | Less Than |
<= | Less than or Equal to |
= | Equal to |
<> | Not Equal to |
BETWEEN | In an inclusive Range |
LIKE | Search for a pattern |
IN | To specify multiple possible values for a column |
Consider the PRODUCTS table having the following records −
ID | ITEM | QUANTITY | PRICE_PER_ITEM |
1 | Chair | 67 | 850.00 |
2 | Ball | 12 | 600.00 |
3 | Jars | 9 | 500.00 |
SELECT ID,
ITEM,
QUANTITY,
PRICE_PER_ITEM
FROM PRODUCTS WHERE ID = 3;
Output:
ID | ITEM | QUANTITY | PRICE_PER_ITEM |
3 | Jars | 9 | 500.00 |
SELECT ID,
ITEM,
QUANTITY
FROM PRODUCTS WHERE PRICE_PER_ITEM > 500.00;
Output:
ID | ITEM | QUANTITY |
1 | Chair | 67 |
2 | Ball | 12 |
SELECT ID,ITEM,PRICE_PER_ITEM
FROM PRODUCTS WHERE ITEM = "Chair";
Output:
ID | ITEM | PRICE_PER_ITEM |
1 | Chair | 850.00 |
Note: multiple conditions in the where clause can be used as per the requirements.
Note: also read about DCL Commands: GRANT and REVOKE
Please follow me to read my latest post on programming and technology if you like my post.
https://www.instagram.com/coderz.py/
https://www.facebook.com/coderz.py
Staying up to the mark is what defines me. Hi all! I’m Rabecca Fatima a keen learner, great enthusiast, ready to take new challenges as stepping stones towards flying colors.
Problem Statement: Given n pairs of parentheses, write a function to generate all combinations of well-formed parentheses. Example…
Given an integer A. Compute and return the square root of A. If A is…
Given a zero-based permutation nums (0-indexed), build an array ans of the same length where…
A heap is a specialized tree-based data structure that satisfies the heap property. It is…
What is the Lowest Common Ancestor? In a tree, the lowest common ancestor (LCA) of…