File: select_except.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (21 lines) | stat: -rw-r--r-- 477 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
SELECT
    * EXCEPT (seqnum) REPLACE (foo as bar, baz as foobar)
FROM my_tbl;

-- Catch potential bugs in unions
select * except (foo) from some_table
union all
select * from another_table;

-- Except is allowed after other fields
select
  1 + 2 as calculated,
  * except (irrelevant)
from my_tbl;

-- This might be redundant with the example above.
-- Demonstrates using multiple except clauses.
select
  foo.* except (some_column),
  bar.* except (other_column)
from my_tbl;