selecting date ranges for a single activity
Posted: Mon Apr 16, 2007 5:07 am
a table having two columns one activity and second date
and data is
ACTIVTY DATE
A 01-MAR-07
A 02-MAR-07
A 03-MAR-07
A 15-MAR-07
A 16-MAR-07
A 17-MAR-07
A 18-MAR-07
RESULT REQUIRED
A 1-MAR-07 TO 3-MAR-07
A 15-MAR-07 TO 18-MAR-07
PLZ HELP
and data is
ACTIVTY DATE
A 01-MAR-07
A 02-MAR-07
A 03-MAR-07
A 15-MAR-07
A 16-MAR-07
A 17-MAR-07
A 18-MAR-07
RESULT REQUIRED
A 1-MAR-07 TO 3-MAR-07
A 15-MAR-07 TO 18-MAR-07
PLZ HELP