SELECT * Except One Column in SQL: How To

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=173
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=173

Sometimes you want to select all columns from a table except for one or two.

If you write SELECT * you get every column. It's easy to write but hard to work with. And typing out all of the columns takes time.

In this video, I'll show you two methods in each database vendor that can make this process easier for you.
⏱ TIMESTAMPS:
00:00 - MySQL
03:00 - Postgres
04:11 - SQL Server
05:20 - Oracle

🔗 VIDEO LINKS:
Queries from this video: https://github.com/bbrumm/databasestar/tree/main/videos/173_select_except

Видео SELECT * Except One Column in SQL: How To канала Database Star