I have a table like below with key and seq. My requirement is that the seq can start anywhere but for a given key if
there is atleast 5 consecutive sequences then i need to flag it as 'paid' else not 'nonpaid'. Can you help we with a plsql code please.
key seq
a 1
a 2
a 3
a 4
a 5
a 7
a 8
a 9
b 1
b 2
b 3
b 4
b 5
b 6
c 1
c 2
c 3
d 5
d 6
d 7
d 8
d 9
e 1
e 3
e 4
f 1
f 4
f 5
f 6
f 7
f 8
output
a=paid (since it has 1-5)
b=paid (since it has 1-5)
c=unpaid
d=paid (since it has 5-9)
e=unpaid
f=paid (since it has 4-8)