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;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|