|
|
Posted by Toby A Inkster on 04/27/07 10:01
Vince Morgan wrote:
> The db is foxpro I beleive, but it could be dbase. No one seems to
> actualy know.
As far as I'm aware (and it is not unknown for me to be wrong on
occasion!) the only databases that use the "SELECT TOP n" syntax to limit
the number of results are Microsoft SQL Server and Microsoft Access.
For those who are interested, the Perl module SQL::Abstract::Limit comes
with a very good manual which explains the differences in syntax for
limiting SELECT queries between common RDBMSs.
Also, http://troels.arvin.dk/db/rdbms/#select-limit has a good write up on
the standards-compliant way of doing things, which databases support the
standards-compliant method, and how to use the proprietary syntaxes for
limiting SELECT queries where standards-compliant mechanisms won't work.
--
Toby A Inkster BSc (Hons) ARCS
http://tobyinkster.co.uk/
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux
* = I'm getting there!
Navigation:
[Reply to this message]
|