mardi 2 février 2016

How to get the last not null value from previous rows

I know that there are a lot of solutions for this but unfortunately I cannot use partition or keyword TOP. Nothing I tried on earlier posts works.

My table looks like this: enter image description here

The result I want is when any completion percentage is NULL it should get the value from last non-value completion percentage, like this:

enter image description here

Aucun commentaire:

Enregistrer un commentaire