Just to mention, similar concept can be found in Google BigQuery. https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-except https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select-replace
út 25. 2. 2020 v 11:18 odesílatel Stanislav Motyčka < stanislav.moty...@gmail.com> napsal: > Hello, > > Sometimes (for tables with many columns) it would be better and easier to > write "SELECT" statement with clause "EXCEPT": > "SELECT * [EXCEPT col1 [,col2]] FROM ..." > > It's easier to write "except" one or two columns from all (*) as to write > names of all columns besides one or two. > What do you thin about it? > > Best regards > Stano Motycka > >
