SEO

#1 (**permalink**) 02-28-2008, 10:28 AM

Im running mysql version 5.0.45

Im trying to run a query Select Top 1 * from <table> order by <column>
desc

but when i run it in phpmyadmin i get this error
SQL query: Documentation

SELECT top1 *
FROM customer
ORDER BY pickup DESC
LIMIT 0 , 30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 * from customer order by pickup desc
LIMIT 0, 30' at line 1

I checked google and it may be that my version is outdated, but, i
dont think that is the case. Any suggestions?

#2 (**permalink**) 02-28-2008, 10:28 AM

On Wed, 26 Sep 2007 02:12:19 +0200, <arthursdomain@gmail.com> wrote:
> Select Top 1

Afaik MySQL doesn't have this (is more of an Access/ MSSQL thing)

SELECT *
FROM table
ORDER BY field
LIMIT 1
--
Rik Wasmus

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Select Top 1 * problem

**Select Top 1 * problem**