SELECT ... LIMIT 1; -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/
On May 19, 2009, at 5:03 PM, Sam Carleton wrote: > I am far from a SQL expert, but I am 99.9% sure there is SQL syntax > to limit > the number of results, I have not looked it up but I will in a little > while... > > I only need one result. Since I am working with the C/C++ API, I > plan to > simply call sqlite3_step() only once. > > Is there any point in using the SQL syntax to limit it to one? > Would the > syntax slow the process down because it simply isn't needed or will > it speed > it up because of all the wonderful internal things going on? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users