In this tutorial, you have learned how to use SQLite LIMIT clause to constrain the number of rows returned by the query. ORDER BY bytes LIMIT 1 OFFSET 2 Code language: SQL (Structured Query Language) ( sql ) The following statement gets the third smallest track on the tracks table. Milliseconds DESC LIMIT 1 OFFSET 1 Code language: SQL (Structured Query Language) ( sql ) The following statement returns the second-longest track in the tracks table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |