Re: To get top 3 records in mysql connectivity
Wednesday, July 21, 2004 03:40 AM
If by 'top 3 records' you mean the first three then get a result set and iterate through for three iterations. I don't believe that MySql supports the 'limit to' command. Note that the first three records will obviously change according to the criteria specified in your 'WHERE', 'ORDER BY' or 'GROUP BY' clauses.