Skip to content
Advertisement

Oracle – Count of number of days a value has changed

I have a requirement to write a query in Oracle as shown in the screenshots below. Any help is greatly appreciated. Thanks a lot in advance. Vadi.

enter image description here

enter image description here

Table with sample data:

Advertisement

Answer

This is the solution of your problem

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement