![]() Note that we can sort by a column that we don't Sorting is by the column specified which is Sorts in reverse and gets the first row after the SELECT definition FROM WORD_LIST_TABLE ORDER BY word DESC LIMIT 1 Returns the id of the word alpha with the SELECT _id FROM WORD_LIST_TABLE WHERE word="alpha" AND definition LIKE "%art%" Selects the word and definition columns of all SELECT word, definition FROM WORD_LIST_TABLE WHERE _id > 2 Gets all the rows in WORD_LIST_TABLE table. The following queries use the previously defined table:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |