Ajay Kumar Bang
New User
Joined: 10 Feb 2023
Posts: 8
Location: Delhi
|
|
|
|
| Code: |
ID | NAME | UNO | RATE
123|JANE|A3|20 ‐------- Day 3
123|JANE|A2|10. -------Day 2
123|JANE|A1|3 ------Day 1
124|ABCD|B3|0 -------Day 3
124|ABCD|B2|10 ------Day 2
124|ABCD|B1|2 -------- Day 1
Expected result,
123|JANE|A3|20
I want to group by id and name, Order by UNO desc, having count (ID) > 1.
But with this I also want to find difference between 123-A3(Day 3) with 123-A2 (Day 2) on RATE if it's greater than 5.
I want to compare only Day 3 and Day 2 and not Day 2 and Day 1.
So I should not get
123|JANE|A2|10 or
124|ABCD|B2|10
Similarly when my job runs on Day 4 it should compare Day 4 and Day 3 only basically last 2 records from the table.should be compared. |
|
|
