QuestionQ13

VerifiedData Operations and Support

A company uses Amazon Redshift as its data warehouse. A data engineer must query a table named orders.complete_orders_history, which has 100 columns. The query must return every column except those named companyId and unique_system_id.

Which Amazon Redshift SQL statement meets this requirement?

Explanation

Amazon Redshift supports SELECT * EXCLUDE column_list to return all columns from a table except the named columns. This syntax is intended for wide tables when only a small subset of columns must be omitted; NOT IN, EXCEPT, and TRUNCATE are not column-exclusion clauses in this context.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!