Difference between revisions of "COMPARISON OPERATORS"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
FROM books | FROM books | ||
WHERE retail > 55 | WHERE retail > 55 | ||
'''The “greater than” (4) comparison operator can also be used with text and date fields.''' | |||
SELECT title | |||
FROM books | |||
WHERE title > 'HO' | |||
[[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Revision as of 17:10, 24 October 2017
COMPARISON OPERATORS
A comparison operator indicates how data should relate to the search value, such as “greater than” or “less than.”
SELECT * FROM books WHERE retail > 55
The “greater than” (4) comparison operator can also be used with text and date fields.
SELECT title FROM books WHERE title > 'HO'