TOP is a microsoft SQL extension. MySQL uses the LIMIT clause.
for instance, the following is a rather typical "top 10" sql query: select some_column, sum(another_column) total from some_table group by some_column order by total desc LIMIT 10 On Wed, 28 Jul 2004 14:39:11 -0400, Kamal Ahmed <[EMAIL PROTECTED]> wrote: > Hi, > Does anyone know how to do a TOP function in MySQL ? > > Thanks, > > -Kamal. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
