Top-level fetch first in views

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite2009201120132015201720192021⊘ 3.5.7 - 3.43.0⚠ 2017 - 2022bc⊘ 2008R2✓ 8.4 - 16⊘ 8.3✓ 12cR1 - 21c⊘ 11gR1 - 11gR2⊘ 5.1 - 8.0.34✓ 10.6 - 10.11⊘ 5.1 - 10.5⊘ 10.5 - 11.5.8a⊘ 2.0
  1. Use nested query: CREATE VIEW … AS SELECT … FROM (SELECT … FROM … FETCH FIRST …) t
  2. Requires offset (e.g. offset 0 rows)
  3. Requires order by