Difference between revisions of "COMPARISON OPERATORS"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 10: | Line 10: | ||
WHERE title > 'HO' | 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