About this document
SQLite Query Techniques and Examples by Pallavi Bal is a document available to read on EtoBox.
The document provides examples of various SQL queries that can be run using the Chinook database including: LIMIT, ORDER BY, DISTINCT, calculated fields, WHERE clauses, aggregates, GROUP BY, JOINs, and subqueries. Fifteen different SQL concepts and queries are demonstrated including selecting limited records, ordering results, finding unique values, adding calculated fields, filtering on conditions, grouping, aggregating, joining tables, and using subqueries. The examples are numbered SQL1 through SQL15 and
- Author
- Pallavi Bal
- Language
- EN