Hi ,
I have a req where I need to select only the first record from a oracle table via Datastage job .Could any one tell me how to select only the first rec.
Selecting first record from a table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It is a fundamental tenet of database design and usage that it is the database server, not the user, that determines order of storage. Therefore, unless every record is timestamped somehow with the date/time it was inserted (so that you can specify the oldest), there is no such thing as the first record in a table. I believe you need to re-think your requirement.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: