Day 12 (Morning) : Delete Rows & Columns in PostgreSQL | SQL for Data Analysts ๐ฅ
๐น Day 12 of 30 โ Mastering PostgreSQL as a Data Analyst!
In today's session, I practiced deleting specific and multiple rows, and dropping single or multiple columns using PostgreSQL. These are essential SQL skills for cleaning and managing real datasets.
๐ง Key Commands I learned:
DELETE FROM table_name WHERE condition;
DELETE FROM table_name WHERE id IN (...);
ALTER TABLE table_name DROP COLUMN column_name;
Dropping multiple columns using sequential ALTER statements
๐ This is part of my ongoing 30-Day Data Analyst Learning Journey where I post daily progress on Excel, SQL, Dashboards & more.
๐งโ๐ป Follow along & Subscribe โ โช@TechWithNicksโฌ
๐ Note: All data used is fictional and for educational use only.
0