how to avoid duplicate names

Question

My query as follows

 

select b.cmn_minor_code as Course,c.cmn_minor_desc as Eligbility,convert(char(12),b.cbm_batch_start_dt,106) as Startdt,

convert(char(12),b.cbm_batch_end_dt,106) as Enddt from tb_rankwise_coursesettings as a,CO_BATCH_MASTER as b,CO_MINOR_MASTER as c

where a.course = b.cmn_minor_code and a.Rank = 'CHENGR' and b.cbm_active <> 'd'

and b.cmn_minor_code = c.cmn_minor_code

and a.Active <> 'd' and b.cbm_batch_start_dt between '2015-08-01 00:00:00.000' 

 

when i run the above query output as follows

 

Course         Eligbility                        Startdt                Enddt

REO         CHIEF ENGINEER       10 Aug 2015     21 Aug 2015

REO         CHIEF ENGINEER       24 Aug 2015     04 Sep 2015

REO         CHIEF ENGINEER       14 Dec 2015     25 Dec 2015

 

But i want the output as follows

 

Course      Eligbility                      Startdt               Enddt

REO        CHIE ENGINEER   10 Aug 2015      21 Aug 2015

                                               24 Aug 2015       04 Sep 2015

                                               14 Dec 2015       25 Dec 2015

 

for that how to avoid the Course and Eligbility in repeation using my above query

please help me.