Hi Folks,
I have below requirement which have thousands of records need to eliminate records based on last modified time.
Once find the duplication I need to find total number of application based on approved records.
| Modified Time | Date | Application No | Count |
| 10:01 | 1/1/2010 | 1 |
| 10:02 | 1/1/2010 | 2 |
| 10:03 | 1/1/2010 | 3 |
| 10:04 | 1/1/2010 | 4 |
| 10:05 | 1/1/2010 | 1 |
| 10:06 | 1/1/2010 | 1 |
| 10:07 | 1/1/2010 | 5 |
| 10:08 | 1/1/2010 | 6 |
| 10:09 | 1/1/2010 | 3 |
| 10:10 | 1/1/2010 | 3 |
| Count | 6 |
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.