SQL Between Clause

 
Tips>>SQL

MAKE FULL WEB APPLICATION WITH JUST SQL KNOWLEDGE? CLICK HERE

 

The BETWEEN condition allows you to get back values within a range. The BETWEEN operator selects a range of data between two values. These values can be numbers, text, or dates. The BETWEEN function can be used in any valid SQL statement - select, insert, update, or delete.

The syntax for the BETWEEN condition is:

SELECT columns FROM tables WHERE column1 between value1 and value2;

EXAMPLE #1 :-

NAME OF SUPPLIER SUPPLIER ID
Samudri Store 5000
Krishna Store 5006
Newland Store 5020


The following is an SQL statement that uses the BETWEEN function:

SELECT *FROM suppliers WHERE supplier_id
between 5000 AND 5010;

This would return all rows where the supplier _id is between 5000 and 5010, inclusive. It is equivalent to the following SQL statement:-

RESULT:-

NAME OF SUPPLIER SUPPLIER ID
Krishna Store

5006

 

If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.

 
E-mail : sales@virtualsplat.com
Phone : +91-9892413501

+91-9967648641

+91-9967648641