topic How to fetch a get a data for this scenario in App Development

How to fetch a get a data for this scenario

Kumar6 — Tue, 21 Dec 2021 21:56:36 GMT

Hello all,

I am facing problem in deriving the solution for below problem

Load

dt_diff, sequence

5 , 1

45, 2

90, 3

180, 4

270, 5

I wanted a solution like this below

dt_diff, sequence

5 , 0

45, 1

90, 2

180, 3

270, 4

Anything less than dt_diff 45 should come under the sequence 0, then it should populate sequentially

hope my question is clear

any inputs appreciated

Re: How to fetch a get a data for this scenario

Taoufiq_Zarra — Thu, 06 May 2021 08:55:13 GMT

@Kumar6 just to understand what is the expected output from this :

dt_diff, sequence

5 , 1

45, 2

90, 3

4,4

180, 5

270, 6