We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
update daily d2 set (avg_30day, busy_hour_value, busy_hour) = (select avg(d1.daily_metric), max(h1.metric_value), h1.timestamp from daily d1 left outer join hourly h1 on d1.id = h1.id and d1.timestamp = trunc (h1.timestamp) where d1.id = d2.id and d1.timestamp > (d2.timestamp - 29) and d1.timestamp <= d2.timestamp)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how to find out the count of records based on the subfolders paths||11||51|
|minium over 4 numeric columns for each row in oracle||2||56|
|Pass multiple values or string arrays in java as a parameter||3||74|
|only show the last 365 days||6||35|
Join the community of 500,000 technology professionals and ask your questions.