SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ85

Load and leverage structured, semi-structured, and unstructured data

A user has a Snowflake table containing 50 columns.

Which keyword can be used with the SELECT command to omit a column named MODIFIED_DT when querying the records?

Explanation

Snowflake’s SELECT * EXCLUDE <column_name> syntax returns all columns except the specified column. Therefore, EXCLUDE MODIFIED_DT omits MODIFIED_DT from the query result.

Learn more

Community Discussion

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