|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
Messages: n/a
Hébergeur: |
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 |
|
![]() |
| Outils de la discussion | |
|
|