Last Record
Moderators: chulett, rschirm, roy
Last Record
Hi,
I want to know how to extract the last record of a particular column.
I have 2 columns
A B
1 2
2 3
3 NULL
B should have one value greater than A. The last Record of A should be null. How to extract the last record of A..
I want to know how to extract the last record of a particular column.
I have 2 columns
A B
1 2
2 3
3 NULL
B should have one value greater than A. The last Record of A should be null. How to extract the last record of A..
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
What about an update after the load, like
Code: Select all
update tgt set b=null where a=(select max(a) from tgt)
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Etiquette Notekris_r wrote:Any idea Guys?
This is an all volunteer site. Folks post as and when they can. If you want urgent answers sign up with your support provider for premium service and learn the true cost of "urgent". Don't push. Not everyone is in your time zone, and we do need our sleep.
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.