Filter result set (java)

[cnapagoda]

I'm getting ResultSet time between time period.

EX:


SELECT * FROM tbl_name WHERE date BETWEEN month1 AND month5;



then I want to divided that ResultSet in to month1 to month2, month2 to month 3, etc. if any one know how to do it reply this..

thanx....

[ronverdonk]

I cannot see how you want to 'divide' that result set. Into what? Using MySQL? Using Java? In the latter case you are in the wrong forum.

Selecting a set per year and then UNIONing them gives the same rsult set as this one. So please explain a bit more what it is you want to achive.

Ronald