SQL for limitation

Please discuss general Delphi programming topics here.

SQL for limitation

Postby hacchan » January 7th, 2005, 5:44 am

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,
hacchan
Active Member
Active Member
 
Posts: 6
Joined: December 8th, 2004, 3:30 am
Location: indonesia

Postby Stefan » January 11th, 2005, 1:26 pm

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
User avatar
Stefan
Moderator
Moderator
 
Posts: 128
Joined: September 27th, 2004, 9:40 am
Location: Tilburg, The Netherlands


Return to Delphi Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron