intersect, select w/o from

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200820102012201420162018202020223.5.72008R28.38.0.3110.32.0