facebook pixel
Most people think this is not possible in SQL šŸ‘‡ But some engines support this magic: SELECT * EXCEPT (col1, col2) Means: šŸ‘‰ Select everything except few columns. Supported in: BigQuery, Spark SQL, ClickHouse, Snowflake, DuckDB. Not supported in: MySQL, Postgres, Oracle, SQL Server. Save this. It will help in real projects šŸ’Æ Follow @dataengineeringtamil #SQL #DataEngineeringtamil #BigData #Analytics #Database BigQuery SparkSQL Snowflake ClickHouse DuckDB TechReels Programming Developers Data

Ā 59.6k

Ā 2.3k

Ā 18

Ā 59.6k

    Suggested Credits
    Tags, Events, and Projects