View ColdFusion Source code
This example shows the WITH TIES option.
Notice that while the select statement limits the rows to 11, the WITH TIES option produces 12 rows.
RowStateNameStatehood
1Hawaii1959-08-21 00:00:00.0
2Alaska1959-01-03 00:00:00.0
3Arizona1912-02-14 00:00:00.0
4New Mexico1912-01-06 00:00:00.0
5Oklahoma1907-11-16 00:00:00.0
6Utah1896-01-04 00:00:00.0
7Wyoming1890-07-10 00:00:00.0
8Idaho1890-07-03 00:00:00.0
9Washington1889-11-11 00:00:00.0
10Montana1889-11-08 00:00:00.0
11South Dakota1889-11-02 00:00:00.0
12North Dakota1889-11-02 00:00:00.0

Also check out: CFM Zen Garden, and jQuery Zen Garden.

Database: Phillip Senn
Design: Ryan Carroll