1. Forum
  3. T24 Technical Discussions
  5. T42 Data Migration
  7. how can i retrieve latest record
× Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…

how can i retrieve latest record

  • tester111
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 9 months ago #21396 by tester111
how can i retrieve latest record was created by tester111
i would like to ask about the ID with date and another column storing time of the updated record. how can i retrieve latest record for each ID from sql script?
IDXXX-YYYYMMDD

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
6 years 8 months ago #21408 by VK
Replied by VK on topic how can i retrieve latest record
Hi
Did I get it right that you have, for examples, IDs like:
ID001-20171002
ID001-20171102
ID002-20160101
ID002-20170101
... and you want to get only:
ID001-20171102
ID002-20170101

Is this so?
Cheers
VK

Please Log in or Create an account to join the conversation.

  1. Forum
  3. T24 Technical Discussions
  5. T42 Data Migration
  7. how can i retrieve latest record
Time to create page: 0.066 seconds