{"id":14,"date":"2015-11-23T11:02:29","date_gmt":"2015-11-23T04:02:29","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=14"},"modified":"2024-04-16T11:21:32","modified_gmt":"2024-04-16T04:21:32","slug":"sqlite-select","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-select\/","title":{"rendered":"SQLite Select"},"content":{"rendered":"\n

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

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

The following example show how to use the SELECT<\/code> statement to perform a simple calculation:<\/p>\n\n\n

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