select date1,count(sno)as sno,COUNT(distinct(pcode))as pcode,; count(distinct(vno))as vno,; SUM(gswt) as gswt,SUM(trwt)as trwt, SUM(ntwt)as ntwt, SUM(cash)as cash; from weights; where between(date1,f_date1,t_date1); order by date1; GROUP BY date1; into cursor abcd