Averaging Columns of Information

Averaging Columns of Information

How do I get the average of three columns for each row of a table that has four columns of information?

Let’s say you have a table called Test with four columns like this:

ID  Col1  Col2  Col31    10    20    20

This SELECT statement will return an average value for Col1, Col2 and Col3:

SELECT ((Col1+Col2+Col3)/3) AS ColAvg FROM TestColAvg                       ---------------------------- 16.666666(1 row(s) affected)

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular