Hi Guys
i hava some required like this
having following columns
id nubber(pk),event_cd(pk),date(timestamp).dr_ky
123,6210,2010/10/10,null
123,6200,2010/10/11,1010
123,6261,2010/10/11,1212
data like
f 6200 event exists and 6261 event exists and 6261 date >= 6200 date then ignore 6200 event
How to implement this logic
Thanks in advance for your help.
How to implement this logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: