# @dataengineeringtamil on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DTptEN5kpne
- **Gondola URL:** https://gondola.cc/posts/63366276-dataengineeringtamil-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/13977915e1.jpg
- **Posted:** 2026-01-18T12:14:43.000+00:00
- **Account Owner:** Data Engineering Tamil (@dataengineeringtamil) — https://gondola.cc/dataengineeringtamil

## Caption

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

## Stats

- **Views:** 16,939
- **Likes:** 2,314
- **Shares:** 0
- **Comments:** 18

## Tags

database, bigdata, sql, dataengineeringtamil, analytics

---
Copyright (c) Gondola