Distinct data
Hi everyone!!
I have a table that looks like as follows :
memberName3 memberDesig3
----------- ------------
Sanjay Bagaria D011
Vinay Kumar Agarwal D011
Deepak Choudhary, Raghupati Bhuwalka D011
Ramesh Kumar Khaitan D011
Raghupati Bhuwalka, Ramesh Kumar Khaitan D011
Raghupati Bhuwalka, Ronaq Gupta D011
Raakesh Jain, Vikas Tibrewal D011
Naresh Kumar Jalan, Ramesh Kumar Khaitan D011
Ramesh Goenka, Siddharth Jain D011
Dr. Ram Pal Widhawan, Nathmal Nevatia, Sanjay Chiraniwala D011
Mahesh Kr. Shah, Padam Kumar Agarwal, Sanjay Bagaria D011
Hemant Manek, Ramesh Goenka D011
Aniruddh Daga, Ashok Chowdhary, Raakesh Jain D011
Ashok Chowdhary, Jogindar Raj Agarwal D011
Siddharth Jain D011
Harkesh Gupta D011
Vikram Doogar D011
Anil Pargal, Pradeep Rawat D011
Sunil Poddar D011
Siddharth Jain, Viren Mehra D011
I need a query which will return me only the distinct names i.e each name will appear only once in a row and one row will contain only one name which means that distinct rows for distinct rows.
the repeations of the names separated by "," has to be remeoved.
I need only one column Member to be returned by the query.
Hope this can be done?
Thanks in advance.
|