View Single Post

  #2 (permalink)  
Old 03-08-2007
Paul Lautman
 
Posts: n/a
Default Re: SELECT query with negative LIMIT?

antoniog wrote:
> Is possible execute the query below:
>
> SELECT * FROM table LIMIT -10
>
> I need extract the last 10 rows inserted in table.
>
> That query running?
>
> Thank you for all
>
> antoniog


Use an auto_increment column and sort DESC then use limit 10


Reply With Quote