Re: Does MySQL know the SELECT TOP statement?
Posted by:
Tal Orlik
Date: August 25, 2006 07:03AM
Hi,
unfortunately it does not.
the way to do the same in MySQL you have to use the LIMIT function
e.g. SELECT * FROM tbl LIMIT 0,10
that will select the top 10 records from the database.
hope that helps,
T.
Subject
Views
Written By
Posted
107072
December 01, 2004 07:02PM
47375
December 03, 2004 02:35PM
Re: Does MySQL know the SELECT TOP statement?
94562
August 25, 2006 07:03AM
27578
October 15, 2006 03:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.