SQLite Database

5.

Querying Data with SELECT

5.1.

Basic SELECT Operations

5.1.1.

Selecting All Columns with Asterisk

5.1.2.

Selecting Specific Columns

5.1.3.

Using Column Aliases with AS

5.1.4.

Using Table Aliases

5.1.5.

Literal Values in SELECT

5.2.

Filtering Data with WHERE

5.2.1.

Comparison Operators

5.2.1.1.

5.2.1.2.

5.2.1.3.

5.2.1.4.

5.2.1.5.

Less Than or Equal

5.2.1.6.

Greater Than or Equal

5.2.2.

Logical Operators

5.2.2.1.

5.2.2.2.

5.2.2.3.

5.2.3.

BETWEEN Operator

5.2.4.

5.2.5.

5.2.5.1.

Wildcards Percent and Underscore

5.2.5.2.

Case Sensitivity

5.2.6.

5.2.7.

IS NULL and IS NOT NULL

5.2.8.

Pattern Matching Techniques

5.3.

Sorting Results

5.3.1.

ORDER BY Clause

5.3.2.

Ascending Order

5.3.3.

Descending Order

5.3.4.

Sorting by Multiple Columns

5.3.5.

Handling NULL Values in Sorting

5.3.6.

Custom Sort Orders

5.4.

Limiting and Pagination

5.4.1.

5.4.2.

5.4.3.

Pagination Strategies

5.4.4.

Performance Considerations

5.5.

Aggregate Functions

5.5.1.

5.5.2.

5.5.3.

5.5.4.

5.5.5.

5.5.6.

GROUP_CONCAT Function

5.5.7.

Custom Aggregation

5.6.

5.6.1.

GROUP BY Clause

5.6.2.

Grouping by Single Column

5.6.3.

Grouping by Multiple Columns

5.6.4.

HAVING Clause for Group Filtering

5.6.5.

Aggregate Functions with Grouping

5.7.

Combining Result Sets

5.7.1.

5.7.2.

UNION ALL Operator

5.7.3.

INTERSECT Operator

5.7.4.

EXCEPT Operator

5.7.5.

Set Operation Rules

5.8.

5.8.1.

5.8.2.

5.8.3.

RIGHT JOIN Emulation

5.8.4.

FULL OUTER JOIN Emulation

5.8.5.

5.8.6.

Using ON Clause

5.8.7.

Using USING Clause

5.8.8.

5.8.9.

Multiple Table Joins

5.8.10.

Join Performance Optimization

Previous

4. Data Manipulation Language

Go to top

Next

6. Advanced SQL Features