Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Luis171190
Contributor
Contributor

Last record by date

Good afternoon, I wanted to know how to obtain the last two records for each day, for the loading of scripts. This is the table I have.

 

materials date
12324199 1/1/2022
12349090 2/1/2022
12390984 3/1/2022
12390985 4/1/2022
12390986 5/1/2022
12391758 6/1/2022
12403498 7/1/2022
12415203 8/1/2022
12419181 1/2/2022
12427423 2/2/2022
12457274 3/2/2022
12494595 4/2/2022
12789952 5/2/2022
11534159 6/2/2022
12076156 7/2/2022
12115855 8/2/2022
12415202 1/3/2022
12151876 2/3/2022
12153645 3/3/2022
12171508 4/3/2022
12427421 5/3/2022
10516043 6/3/2022
11110353 7/3/2022
12947522 8/3/2022

 

Thank you so much!

10 Replies
sidhiq91
Specialist II
Specialist II

@Luis171190  You are not getting Mar data because my data does not contain Mar data, I have included only Jan and Feb.  You can follow the remaining steps.