Re: solve this query

On Oct 11, 3:12 pm, TulsiPravin Majithia <tulsipravin.majit..._at_pyrogroup.com> wrote:
> select _at_rownum:=_at_rownum+1 as ID , c.cnt_cp_id,msisdn , case
> mode_of_subscription when 1 then 'IVR' when 2 then 'SMS' when 3 then
> 'WEB' when 4 then 'WAP' else 'RENUAL' end as
> mode,date_format(submit_time,'%d-%m-%y %r'),trans_id,sa_id,charge/100
> as charge,(select count(*) from tbl_IN_response t1 where
> keyword='SONG' and in_response = 0 and submit_time between '2011-07-15
> 20:31:00'  and '2011-07-15 20:31:50'  ) as total  from tbl_IN_response
> t,tbl_cms_content c,(select _at_rownum:=0)r  where c.cnt_song_id =
> t.sa_idand keyword='SONG' and in_response = 0 and submit_time between
> '2011-07-15 20:31:00'  and '2011-07-15 20:31:50'
>
> it will give the uplicate data plzz help  me

Oh my goodness. I have no idea what "duplicates" you mean, but have you tried "SELECT DISTINCT..."? Received on Wed Oct 12 2011 - 21:50:53 CEST