Regards,
Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Matthew Stuart [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 25, 2007 6:55 AM > To: MySQL email support > Subject: Select question > > I've got this statement to select the last two entries in my db: > > SELECT top 2 * > FROM Content > ORDER BY ContentID desc > > and it works fine because it selects the last two items entered into > the db. However, I only want to be able to select item 2 rather than > both 1 and 2. How do I do that? > > Thanks > > Mat > [JS] What does adding LIMIT 2,1 do? I'm not sure what "SELECT top 2 *" means. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
