Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle BETWEEN Condition      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: BETWEEN

Definition:
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:

SELECT *
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 115 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?