Difference between revisions of "COMPARISON OPERATORS"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==COMPARISON OPERATORS== | ==COMPARISON OPERATORS== | ||
A comparison operator indicates how data should relate to the search value, such as “greater than” or “less than.” | 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' | |||
SELECT title, retail, cost, retail - cost profit | |||
FROM books | |||
WHERE retail-cost < cost * .2 | |||
ORDER BY TITLE | |||
[[#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 17:16, 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'
SELECT title, retail, cost, retail - cost profit FROM books WHERE retail-cost < cost * .2 ORDER BY TITLE