When we use between operator then it compare all the records which match with our given range after BETWEEN operator.
For example if want to select those record form table below where order-amount is from 20000 to 50000
then we use following statement:
SELECT * FROM client_info WHERE order_amount between 20000 and 50000 ;
Actual Table
client_ID | city | order_amount |
A001 | Karachi | 50000 |
A002 | Lahore | 20000 |
B001 | Karachi | 30000 |
B002 | Islamabad | 10000 |
B004 | Karachi | 15000 |
The above statement display the following record.
Selected record with BETWEEN Operator
client_ID | city | order_amount |
A001 | Karachi | 50000 |
A002 | Lahore | 20000 |
B001 | Karachi | 30000 |
Select Command
Distinct clause with Select Command
Where clause In SQL
Logical Operator in SQL SELECT Statement
IN Operator in SQL
BETWEEN Operator in SQL
Use of Wildcards in SQL
LIKE Operator in SQL
ORDER BY Clause in SQL
GROUP BY Clause in SQL
HAVING Clause in SQL
ALIAS In SQL
AS Keyword In SQL
INSERT INTO Command In SQL
Inserting Record In to a Table Form an other Table In SQL
UPDATE Command in SQL
DELETE Command in SQL
AVG Function in SQL