From: Thimble Smith
Date: April 9 1999 1:35am
Subject: Re: Equivalency of TOP predicate?
List-Archive: http://lists.mysql.com/mysql/1554
Message-Id: <19990408183533.Q6306@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

I don't know of a direct equivalent - you will probably need to use
LIMIT; perhaps do a COUNT(*) query before and do the 5% math first,
then use LIMIT.

Tim


On Thu, Apr 08, 1999 at 08:39:24PM -0500, Big Mike wrote:
> What  would be the equivalent of MS's TOP predicate in mySQL? I'm coming
> from a Windows background and am only familiar, so far, with the SQL found
> in the Jet engine (VB5 version). I'm moving from NT-based to UNIX-based web
> apps.
> 
> example: "SELECT TOP 5 PERCENT * FROM table ORDER BY id DESC"
> 
> Are there any resources on the net that describe differences like this and
> their equivalents?
> 
> Mike
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1553@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>