All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql-tests.testcases.with_clause.withExprReferencedInWhereClause.sql Maven / Gradle / Ivy

There is a newer version: 0.289
Show newest version
-- database: presto; groups: with_clause; tables: nation,region; queryType: SELECT
WITH wregion AS (select min(n_regionkey) from nation where n_name >= 'N')
select r_regionkey, r_name from region where r_regionkey IN (SELECT * FROM wregion)




© 2015 - 2024 Weber Informatics LLC | Privacy Policy