Quick Search:
 The Oracle BETWEEN Condition      [Return To Index] Jump to:  


The BETWEEN condition allows retrieving values within a range you specify. It will return the records inclusively, meaning that the end or limit values are also returned. For example, this SQL will return the 'user_id' 1000 through 1050, not 1001 through 1049:

FROM users
WHERE user_id BETWEEN 1000 AND 1050;

The BETWEEN function can be used in any SQL statement, including SELECT, INSERT, UPDATE, and DELETE.

Related Links:

Related Code Snippets:
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org