SQLite Get One result

I know in MySQL, there is a LIMIT feature where you can limit your results.

SELECT *开发者_开发问答 FROM table WHERE id = 'id' LIMIT 0,1

Is there any way to do that in SQLite?

---

You can do the same with SQLite. See: http://www.sqlite.org/lang_select.html