data between loginc

[Amara Suman]

Hi All,

I have table JobOrader it has 5 columns
like (jo_no, jo_type, jo_release, jo_date, jo_livedate)

Using mysql i am counting the jo_type like below

select jo_no,jo_date,jo_livedate,count(*) from joborder
where job_no='1232';

output:-
-------

|jo_no------jo_date------jo_livedate----count(*) |
|-----------------------------------------------------------|
|1232------01-dec-14----05-dec-14--------5 |
|-----------------------------------------------------------|

I want output of different of jo_date and jo_livedate is 5 day i need to generate 5 records as below ...

|--------------------------------------------------------|
|jo_no------date----------count(*) |
|1232------01-dec-14-----------5 |
|1232------02-dec-14-----------5 |
|1232------03-dec-14-----------5 |
|1232------04-dec-14-----------5 |
|1232------05-dec-14-----------5 |
|--------------------------------------------------------|