SQLite: select certain # of records

person Jason Huangfolder_openCode, SQL, SQLitelocal_offer, , access_time May 6, 2010

A column name can be any of the names defined in the CREATE TABLE statement or one of the following special identifiers: “ROWID”, “OID”, or “_ROWID_”. These special identifiers all describe the unique integer key (the rowid) associated with every row of every table. The special identifiers only refer to the row key if the CREATE TABLE statement does not define a real column with the same name. The rowid can be used anywhere a regular column can be used.


-- select the top records:
SELECT * FROM EVENT_LOG
where rowid < 2;

Comment

  1. Check out my lens at http://www.squidoo.com/sqliteprogramming if you want to know more about sqlite.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>