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