Difference between revisions of "COMPARISON OPERATORS"

From rbachwiki
Jump to navigation Jump to search
(Created page with "==COMPARISON OPERATORS== A comparison operator indicates how data should relate to the search value, such as “greater than” or “less than.”")
 
 
(4 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]]

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

Back To Top- Home - Category