|
-
Please help ... SQL query
----
From the HISTORY table we want to Fetch data that is 3 days prior to and 3 days after each of the EVENT_D We do not want the repeat history if the Incident_day events make this data overlap.
EX. Incident-date = 2/18/2011 3 days prior is 2/15 3 days after is 2/21
Incident-date = 2/202011 3 days prior is 2/17 3 days after is 2/23
In this case the data from 2/18 2/21 would be repeated. Only show that once, the Fetch should get the data from 2/15 2/23.
---- can you please help me in writing the query ..
-
Can you clarify further with table definition. What are you trying to select? Is there more than one condition in the query?, how are two incident_involved?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote