[V4MD2] ORDER and LIMIT

[Ruslan Zasukhin]

On 6/24/05 2:10 AM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

Hi Heinrich, 

> 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?


Sergey have found mistake in grammar.

Now it is expected that LIMIT is before ORDER BY.
Sergey fix this now

Ivan, please add such test in our system.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]