travel-net
Posts: 56
|
Posted: 03/11/2004, 12:50 AM |
|
Hello,
How too display only the records with a count value > 2. The count value is working on my grid.
Regards,
Frans
|
|
|
peterr
Posts: 5971
|
Posted: 03/11/2004, 1:06 AM |
|
Use an SQL query that displays only such records. This is usually done by using the HAVING statement. For example:
SELECT country_name, Count(order_id) FROM orders GROUP BY country_name HAVING Count(order_id)>100;
Also see: http://www.google.com/search?q=mysql+HAVING+statement
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
travel-net
Posts: 56
|
Posted: 03/11/2004, 1:09 AM |
|
Hello Peter,
Thanks for the quick reply. I will look at the HAVING statement.
Regards,
Frans
|
|
|
|