Subject | Ordering |
---|---|
Author | mjcook@techie.com |
Post date | 2001-05-14T22:43:17Z |
I have a query that counts the number of street records.
Select street, count(street) as streetcount
from complaint
Where OpenDate between :startdate and :enddate
group by street
I put this in a IB_Grid and it's great -- except I want to sort by the
either value -- street or streetcount by using ordering items. Is that
possible?
Thanks,
Marv
Select street, count(street) as streetcount
from complaint
Where OpenDate between :startdate and :enddate
group by street
I put this in a IB_Grid and it's great -- except I want to sort by the
either value -- street or streetcount by using ordering items. Is that
possible?
Thanks,
Marv