[thelist] An sql problem

Philippe Jadin philippe.jadin at 123piano.com
Sat May 5 06:33:17 CDT 2001


Thank you for your brilliant answers everybody !

> in mysql, philippe, you restrict the number of rows returned using the
> LIMIT keyword
> 
>   SELECT id
>   FROM table
>   WHERE ref < [thisone.ref]
>   ORDER BY ref DESC
>   LIMIT 1
> 
> 
> good one, josh
> 
> 
> rudy






More information about the thelist mailing list