MariaDB Database

  1. Advanced Querying
    1. Joining Tables
      1. INNER JOIN
        1. Syntax and Use Cases
        2. LEFT JOIN
          1. Syntax and Use Cases
          2. RIGHT JOIN
            1. Syntax and Use Cases
            2. FULL OUTER JOIN
              1. Emulation in MariaDB
              2. CROSS JOIN
                1. Cartesian Products
                2. NATURAL JOIN
                  1. Automatic Column Matching
                  2. The USING Clause
                    1. Simplifying Join Conditions
                  3. Subqueries
                    1. Scalar Subqueries
                      1. Multi-row Subqueries
                        1. Correlated Subqueries
                          1. Subqueries in FROM Clause
                            1. Subqueries in WHERE Clause
                              1. Subqueries in SELECT Clause
                              2. Aggregate Functions
                                1. COUNT()
                                  1. SUM()
                                    1. AVG()
                                      1. MIN()
                                        1. MAX()
                                          1. GROUP_CONCAT()
                                          2. Grouping Data
                                            1. GROUP BY Clause
                                              1. Grouping by One or More Columns
                                              2. HAVING Clause for Filtering Groups
                                                1. Filtering Aggregated Results
                                              3. Set Operations
                                                1. UNION
                                                  1. UNION ALL
                                                    1. INTERSECT
                                                      1. EXCEPT
                                                      2. Views
                                                        1. Creating Views (CREATE VIEW)
                                                          1. Modifying Views (ALTER VIEW)
                                                            1. Dropping Views (DROP VIEW)
                                                              1. Updatable Views
                                                                1. Conditions for Updatability

                                                            Previous

                                                            4. Data Types

                                                            Go to top

                                                            Next

                                                            6. Built-in Functions