Re: oracle sql coding [message #370324] |
Wed, 25 August 1999 17:12 |
m a sivan
Messages: 34 Registered: July 1999
|
Member |
|
|
wELL i HAVE A QUERY FOR THAT BUT ITS KINDA SLOW ONE.. AND what I guess is that u want for same bidid.. (if u want for load just change the names of the columns)
select load from load a, load b
where a.load = b.load and months_between(a.startdate,b.startdate) <= 6
I think this should work.
Actually the logic is to do a self join and then find months between. I just am not able to understand your tables structure and primary keys.
Do let me know or else I think u can figure out the SQL urself
|
|
|