Home » RDBMS Server » Server Administration » Re: oracle sql coding
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
Previous Topic: Re: two-dimensional pl/sql table
Next Topic: dynamic pl/sql question
Goto Forum:
  


Current Time: Thu Mar 28 12:31:20 CDT 2024