SQL for limitation

[hacchan]

Hi,
I have a little problem with SQL.
I wrote this :
SELECT * FROM <table_name> ORDER BY <field_name> LIMIT 0,10
but it doesn't work.
I need to show 10 highest products. I wrote it like i used to in MySQL but it seems that Delphi use different writing.
Anyone can help me?
Thanks.

Regards,

[Stefan]

Delphi does not specifically support one implementation of SQL, it is the application's underlying database that determines what dialect you have to use.

Anyway, here's a URL whcih covers this topic extensively:

http://groups.google.nl/groups?hl=nl&lr=&threadm=aae1fe62.0209161432.303036c3%40posting.google.com&rnum=1&prev=/groups%3Fq%3DMySQL%2BLIMIT%2BSQL%26hl%3Dnl%26lr%3D%26selm%3Daae1fe62.0209161432.303036c3%2540posting.google.com%26rnum%3D1

Hope this helps,

Stefan