sql-tests.testcases.with_clause.withSimpleExprInNestedFromClause.sql Maven / Gradle / Ivy
The newest version!
-- database: trino; groups: with_clause; tables: nation; queryType: SELECT
WITH nested AS (SELECT * FROM nation) SELECT count(*) FROM (select * FROM nested) as a