no TOP?

Hi, all

It seems that we donnot have TOP in sqlite, following statement fails:

cur.execute("SELECT TOP 10 FROM table1 WHERE id=1");

I wonder how to achieve it by an alternative way without TOP?

Any help would be appreciated!
                                
--------------
bruce.who.hk
2006-08-23

_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/pysqlite