You can use operators other than equals to select a set of rows that satisfy the search condition. The inequality operators (< and >) can be used to compare numbers, dates, and even character strings.
In Interactive SQL, execute the following query:
SELECT Surname, BirthDate FROM Employees WHERE BirthDate < 'March 13, 1964' ORDER BY BirthDate DESC; |
Surname | BirthDate |
---|---|
Ahmed | 1963-12-12 |
Dill | 1963-07-19 |
Rebeiro | 1963-04-12 |
Garcia | 1963-01-23 |
Pastor | 1962-07-14 |
... | ... |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |