solve this query
From: TulsiPravin Majithia <tulsipravin.majithia_at_pyrogroup.com>
Date: Tue, 11 Oct 2011 04:12:20 -0700 (PDT)
Message-ID: <c6b63061-b7ec-44c0-9d7e-f01dbcc01c63_at_u4g2000prl.googlegroups.com>
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'
Date: Tue, 11 Oct 2011 04:12:20 -0700 (PDT)
Message-ID: <c6b63061-b7ec-44c0-9d7e-f01dbcc01c63_at_u4g2000prl.googlegroups.com>
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 Received on Tue Oct 11 2011 - 13:12:20 CEST