MariaDB Database

  1. Advanced MariaDB Features
    1. Window Functions
      1. OVER() Clause
        1. Partitioning (PARTITION BY)
          1. Ordering (ORDER BY)
            1. Framing
              1. ROWS
                1. RANGE
                2. Common Window Functions
                  1. ROW_NUMBER
                    1. RANK
                      1. DENSE_RANK
                        1. LEAD
                          1. LAG
                        2. Common Table Expressions (CTEs)
                          1. The WITH Clause
                            1. Recursive CTEs
                              1. Syntax and Use Cases
                            2. Temporal Data Tables
                              1. System-Versioned Tables
                                1. Enabling System Versioning
                                  1. Querying Historical Data
                                  2. Application-Time Periods
                                    1. Defining Application Time Periods
                                      1. Querying with Application Time
                                    2. Dynamic Columns
                                      1. Creating Dynamic Columns
                                        1. Accessing Dynamic Column Data
                                          1. Use Cases and Limitations
                                          2. Sequences
                                            1. Creating Sequences (CREATE SEQUENCE)
                                              1. Using Sequences in Tables
                                                1. Managing Sequence Values

                                              Previous

                                              6. Built-in Functions

                                              Go to top

                                              Next

                                              8. Storage Engines