How to spread the average between two intervals in oracle?

by arnoldo.moen , in category: MySQL , 7 months ago

How to spread the average between two intervals in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by larissa , 7 months ago

@arnoldo.moen 

To spread the average between two intervals in Oracle, you can use the following SQL query:

1
2
SELECT (interval_start + interval_end) / 2 AS average_interval
FROM your_table_name;


In this query, replace your_table_name with the name of your table and interval_start and interval_end with the columns that represent the starting and ending points of your interval. This query will calculate the average of the intervals for each row in the table.