LIMIT was not included in the SQL92 SQL standards and very few vendors implement all of SQL99; the use of ANSI standards to promote "portable" programs has always been beset by this kind of problems.
Mark Charette Former ANSI X3H3.1 member -----Original Message----- From: Alberto Serra [mailto:[EMAIL PROTECTED]] SELECT extract('year', time), extract('month', time) count(*) as monthly_views FROM visitors group by extract('year', time), extract('month', time) order by monthly_view desc limit 1 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php