Hi, There is more than one way to skin a cat
Does mySQL have vailable the command "set rowcount n"? if so... set rowcount 1 select x from y order by x desc Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter Area Health Service Phone +61 2 49214193 Fax +61 2 49214191 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 02/04/2004 2:43:58 pm >>> unfortunately TOP's not supported in most (if not all?) mySQL, I think the way is to use LIMIT. ( from mySQL.org ... SELECT a FROM tbl_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10 ) ----- Original Message ----- From: "Barry Beattie" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, April 02, 2004 2:38 PM Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? do a decending/reverse order and select top 1 select top 1 from tGroup DEC -----Original Message----- From: rob [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:35 PM To: CFAussie Mailing List Subject: [cfaussie] how can i last result in a table (mysql) ??? sorry i know a dumb question but i really need to know!! its friday!!! Robert Shaw Online Learning [EMAIL PROTECTED] MLC School Rowley Street Burwood 2134 Phone: 97471266 Mobile: 0422222515 Fax: 97453254 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
