Similar to using DISTINCT COUNT in SQL, did you know that you can use DISTINCT COUNT in your pivot tables as well to count the number of unique values? This is a lesser-known feature of Excel that is really helpful in analyzing unique values in your pivot table without needing to create separate tables! #Excel #Data #datascience #analyst #corporatelife 💻 | Excelwithkyle23

Add or drop identity property for an existing SQL Server column

ALTER e DROP TABLE - Alterar e Excluir Tabelas e Colunas - SQL Server

SQL DROP TABLE statement overview

SQL PIVOT and SQL UNPIVOT Examples to Transform Data