Difference between revisions of "BETWEEN AND Operator"
Jump to navigation
Jump to search
(Created page with " The BETWEEN . . . AND comparison operator is used when searching a field for values falling within a specified range SELECT title, pubid FROM books WHERE pubid BETWEEN 1...") |
|||
| Line 6: | Line 6: | ||
WHERE pubid BETWEEN 1 AND 3 | WHERE pubid BETWEEN 1 AND 3 | ||
SELECT title | SELECT title | ||
FROM books | FROM books | ||
WHERE title BETWEEN 'A' AND 'D' | WHERE title BETWEEN 'A' AND 'D' | ||
[[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Latest revision as of 22:06, 25 October 2017
The BETWEEN . . . AND comparison operator is used when searching a field for values falling within a specified range
SELECT title, pubid FROM books WHERE pubid BETWEEN 1 AND 3
SELECT title FROM books WHERE title BETWEEN 'A' AND 'D'