Hi everyone,

I need help in finding distinct values of data from a table. I have a table that has 3 columns or fields memName1,memName2,memName3 which contains multiple names separated by ",".I now want to obtain the distinct names that appear in these columns into one single column.

I am not able to construct a proper sql query. Can anyone help me with this??

Thanks in advance

What do you mean? Do you want to concatenate the columns like "memName1, memName2, memName3" or do you want to split out the date like this:

FROM:
memName1
FirstData, SecondData, thirdData

TO:
NewColumn
FirstData
SecondData
ThirdData
etc.



mmcdonal

Sorry, split out the data, not the date.

mmcdonal

Or, like this...

FROM:
memName1
FirstData, SecondData, thirdData

TO:
New Column1 NewColumn2 NewColumn3
FirstData SecondData ThirdData



mmcdonal

First of all I want concatenate the values in memName1,memName2,memName3 then when I get a composite value I want to obtain the distinct names in to another column or variable.

from:
memName1,memName2,memName3

to
New Column

What is the starting format, and the ending format? Please use sample data.


mmcdonal

Well I am giving some sample data as below:


memName1:

Shekhar Mehta
Aniruddh Daga
Aniruddh Daga, Nisheeth Totla
Virendra Singhvi
Raakesh Jain
Pradeep Tibrewal

memName2:

Naresh Kumar Jalan
Shekhar Mehta
Shekhar Mehta
Raj Somani
Sunil Poddar

memName3:

Vinay Agarwal
Deepak Choudhary, Raghupati Bhuwalka
Sanjay Bagaria
Raghupati Bhuwalka, Ramesh Khaitan
Nathmal Neotia, Ram Pal Widhawan, S Chiraniwala
Mahesh Shah, Padam Agarwal, Sanjay Bagaria
Sunil Poddar

I need a query which will return me the distinct names only into one column or as one single dataset that appear in the 3 columns memName1,memName2,memName3.

the columns memName1,memName2,memName3 are text fields and the return column also has to be a text field.



It will be great if such a query can be constructed.
Thanks

So, using the first value in each field, your new column should look like:

Shekhar, Mehta Naresh Kumar Jalan, Vinay Agarwal

Is this correct?

Kevin


dartcoach

My new column should have each single name as a single row value and names will not be separated by commas and not repeated i.e distinct rows only

Could you give me an example of what you want the data to look like?

Kevin

dartcoach