QuestionQ69Verified/Load and leverage structured, semi-structured, and unstructured dataCopy linkReport a problemAsk AstroTutorSave questionWhat is the purpose of using the SELECT * SQL statement in Snowflake?ATo select all rows from a tableBTo select all columns from a tableCTo select all queries in a databaseDTo select the first 10 columns from a tableShow AnswerAnswerExplanationIn Snowflake, * in a SELECT list is shorthand for returning all columns of the specified object (or all referenced objects when unqualified).Learn moreSELECT | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion