Alex Rivera | Logout

How universal is the LIMIT statement in SQL?

Asked 2009-10-06T23:15:44.567
24

I'm in the process of generalizing a Django DB replication app and it uses the statement:

SELECT %s FROM %s LIMIT 1

to fetch 1 row and use the Python DBAPI to describe the fields, it works fine with ORACLE and MySQL but, how cross platform is the LIMIT statement?

sql database rdbms
Edit
Report

1 Answer

12

http://en.wikipedia.org/wiki/Select_(SQL)#Limiting_result_rows lists all of the major variants of the select command.

I believe the best way to do this is to use the SET ROWCOUNT command before your SELECT statement.

So, for you:

SET ROWCOUNT 1
SELECT %s FROM %s
answered 2009-10-06T23:24:44.570

Your Answer