Azure SQL Video
13 page views
183 video views
2025, May 15, Thursday

#125 Get correlation between values in Azure SQL Server

Learn how to calculate the correlation between variables using Azure SQL. Essential techniques and functions for efficient statistical analysis

We will know the techniques:

🔹Pearson's correlation formula;
🔹Declare variable of type table (DECLARE, TABLE, INSERT INTO, VALUES);
🔹Calculate the average of the values (AVG, CTE);
🔹Cartesian product of values (FROM, CROSS JOIN);
🔹Calculate square root and power value (SQRT, POWER);
🔹Retrieve table rows (SELECT, COLUMNS, FROM, TABLE);
Transform rows into columns (PIVOT, MAX, FOR, IN); 🔹
🔹Obtain the correlation between two variables;