{"id":14,"date":"2015-11-23T11:02:29","date_gmt":"2015-11-23T04:02:29","guid":{"rendered":"https:\/\/web.archive.org\/web\/20230707170429\/http:\/\/www.sqlitetutorial.net\/?page_id=14"},"modified":"2022-04-03T14:55:40","modified_gmt":"2022-04-03T07:55:40","slug":"sqlite-select","status":"publish","type":"page","link":"https:\/\/web.archive.org\/web\/20230707170429\/https:\/\/www.sqlitetutorial.net\/sqlite-select\/","title":{"rendered":"SQLite Select"},"content":{"rendered":"\r\n

Summary<\/strong>: in this tutorial, you will learn how to use SQLite SELECT<\/code> statement to query data from a single table.<\/p>\r\n\r\n\r\n\r\n

The SELECT<\/code> statement is one of the most commonly used statements in SQL. The SQLite SELECT<\/code> statement provides all features of the SELECT<\/code> statement in SQL standard.<\/p>\r\n\r\n\r\n\r\n

Simple uses of SELECT<\/code> statement<\/h2>\r\n\r\n\r\n\r\n

You can use the SELECT<\/code> statement to perform a simple calculation as follows:<\/p>\r\n\r\n\r\n

SELECT<\/span>\t1<\/span> + 1<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\r\n\r\n\r\n
Try It<\/a><\/p>\r\n\r\n\r\n\r\n
\"SQLite<\/figure>\r\n\r\n\r\n\r\n
You can use multiple expressions in the SELECT<\/code> statement as follows:<\/p>\r\n\r\n\r\n
SELECT<\/span> \r\n   10<\/span> \/ 5<\/span>, \r\n   2<\/span> * 4<\/span> ;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\r\n\r\n\r\n
\"SQLite<\/figure>\r\n\r\n\r\n\r\n
Querying data from a table using the SELECT<\/code> statement<\/h2>\r\n\r\n\r\n\r\n
We often use the SELECT<\/code> statement to query data from one or more table. The syntax of the SELECT<\/code> statement is as follows:<\/p>\r\n\r\n\r\n
SELECT<\/span> DISTINCT<\/span> column_list\r\nFROM<\/span> table_list\r\n  JOIN<\/span> table<\/span> ON<\/span> join_condition\r\nWHERE<\/span> row_filter\r\nORDER<\/span> BY<\/span> column<\/span>\r\nLIMIT<\/span> count<\/span> OFFSET<\/span> offset<\/span>\r\nGROUP<\/span> BY<\/span> column<\/span>\r\nHAVING<\/span> group_filter;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\r\n\r\n\r\n
The SELECT<\/code> statement is the most complex statement in SQLite. To help easier to understand each part, we will break the SELECT<\/code> statement into multiple easy-to-understand tutorials.<\/p>\r\n\r\n\r\n\r\n
Try It<\/a><\/p>\r\n\r\n\r\n\r\n