Code Forums - View Single Post

kamaltherocky · 06-10-2005, 02:35 AM

Hi

I think you are using MySQL as your DB.

To Limit the number of rows to 3, the Syntax in MySQL is

SELECT product, descr, email
FROM products
LIMIT 10

The one what you have written works in SQL Server.

Thanks
kamal

06-10-2005, 02:35 AM	#2 (permalink)
kamaltherocky Registered User Join Date: Jun 2005 Posts: 3	MySQL Syntax Hi I think you are using MySQL as your DB. To Limit the number of rows to 3, the Syntax in MySQL is SELECT product, descr, email FROM products LIMIT 10 The one what you have written works in SQL Server. Thanks kamal