[V4MD2] ORDER and LIMIT

Heinrich Ruoff heinrichruoff at gmail.com
Fri Jun 24 01:10:57 CDT 2005


I try to order records an then limit the selection to 
the first 20 records:

SELECT * FROM tb_test ORDER BY id LIMIT 0,20
not working :-(

SELECT * FROM tb_test LIMIT 0,20 -> is working
SELECT * FROM tb_test ORDER BY id -> is working

Is there a different syntax required?

Heinrich


More information about the Valentina-beta mailing list