SQLite Database

  1. Querying Data with SELECT
    1. Basic SELECT Operations
      1. Selecting All Columns with Asterisk
        1. Selecting Specific Columns
          1. Using Column Aliases with AS
            1. Using Table Aliases
              1. Literal Values in SELECT
              2. Filtering Data with WHERE
                1. Comparison Operators
                  1. Equality
                    1. Inequality
                      1. Less Than
                        1. Greater Than
                          1. Less Than or Equal
                            1. Greater Than or Equal
                            2. Logical Operators
                              1. AND
                                1. OR
                                  1. NOT
                                  2. BETWEEN Operator
                                    1. IN Operator
                                      1. LIKE Operator
                                        1. Wildcards Percent and Underscore
                                          1. Case Sensitivity
                                          2. GLOB Operator
                                            1. IS NULL and IS NOT NULL
                                              1. Pattern Matching Techniques
                                              2. Sorting Results
                                                1. ORDER BY Clause
                                                  1. Ascending Order
                                                    1. Descending Order
                                                      1. Sorting by Multiple Columns
                                                        1. Handling NULL Values in Sorting
                                                          1. Custom Sort Orders
                                                          2. Limiting and Pagination
                                                            1. LIMIT Clause
                                                              1. OFFSET Clause
                                                                1. Pagination Strategies
                                                                  1. Performance Considerations
                                                                  2. Aggregate Functions
                                                                    1. COUNT Function
                                                                      1. SUM Function
                                                                        1. AVG Function
                                                                          1. MIN Function
                                                                            1. MAX Function
                                                                              1. GROUP_CONCAT Function
                                                                                1. Custom Aggregation
                                                                                2. Grouping Data
                                                                                  1. GROUP BY Clause
                                                                                    1. Grouping by Single Column
                                                                                      1. Grouping by Multiple Columns
                                                                                        1. HAVING Clause for Group Filtering
                                                                                          1. Aggregate Functions with Grouping
                                                                                          2. Combining Result Sets
                                                                                            1. UNION Operator
                                                                                              1. UNION ALL Operator
                                                                                                1. INTERSECT Operator
                                                                                                  1. EXCEPT Operator
                                                                                                    1. Set Operation Rules
                                                                                                    2. Joining Tables
                                                                                                      1. INNER JOIN
                                                                                                        1. LEFT JOIN
                                                                                                          1. RIGHT JOIN Emulation
                                                                                                            1. FULL OUTER JOIN Emulation
                                                                                                              1. CROSS JOIN
                                                                                                                1. Using ON Clause
                                                                                                                  1. Using USING Clause
                                                                                                                    1. Self-Joins
                                                                                                                      1. Multiple Table Joins
                                                                                                                        1. Join Performance Optimization

                                                                                                                      Previous

                                                                                                                      4. Data Manipulation Language

                                                                                                                      Go to top

                                                                                                                      Next

                                                                                                                      6. Advanced SQL Features