Datasheet

Writing Simple Queries 31
> (Greater Than)
The > operator evaluates to TRUE if the left side (expression or value) of the operator is
greater than the right side of the operator.
SELECT first_name || ‘ ‘ || last_name “Name”, commission_pct
FROM employees
WHERE commission_pct > .35;
Name COMMISSION_PCT
------------------------------------------ --------------
John Russell .4
<= (Less Than or Equal to)
The <= operator evaluates to TRUE if the left side (expression or value) of the operator is less
than or equal to the right side of the operator.
SELECT first_name || ‘ ‘ || last_name “Name”, commission_pct
FROM employees
WHERE commission_pct <= .15;
Name COMMISSION_PCT
------------------------------------------ --------------
Oliver Tuvault .15
Danielle Greene .15
Mattea Marvins .1
David Lee .1
Sundar Ande .1
Amit Banda .1
William Smith .15
Elizabeth Bates .15
Sundita Kumar .1
Kimberely Grant .15
Charles Johnson .1
11 rows selected.
>= (Greater Than or Equal to)
The >= operator evaluates to TRUE if the left side (expression or value) of the operator is
greater than or equal to the right side of the operator.
SELECT first_name || ‘ ‘ || last_name “Name”, commission_pct
FROM employees
WHERE commission_pct >= .35;
95127c01.indd 31 2/18/09 6:37:09 AM