In MS SQL Server (T-SQL) you say SELECT TOP n ........ In MySQL you use:
SELECT .... LIMIT n (http://dev.mysql.com/doc/mysql/en/SELECT.html) There is no direct equivalent to SELECT TOP n PERCENT.... Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Kamal Ahmed" <[EMAIL PROTECTED]> wrote on 07/28/2004 02:39:11 PM: > 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] >
