Need help in Preparing Query

[puja123p]

Hi,

I have the following sample data where the battery no. is coming as duplicate.

I need to find the numbers where the Battery are duplicates. As in this case, there are 4 duplicates interlinked, all the 4 numbers should come in the Duplicates column. Example of the output data is attached in 2nd Table.

May please help in the query.

Thanks

Number	Battery number
AD626AR16N1H20260	TB2HN1919391,TB2HN1X19389
AD626AR13N1H21849	TB2HN1X19389,TB2HN1119227
AD626AR17N1H21594	TB2HN1520008,TB2HN1X19238
AD626AR1XN1H20133	TB2HN1119227,TB2HN1X19238

Output Data

Number	Battery number	Duplicate
AD626AR16N1H20260	TB2HN1919391,TB2HN1X19389	AD626AR16N1H20260, AD626AR13N1H21849, AD626AR17N1H21594, AD626AR1XN1H20133
AD626AR13N1H21849	TB2HN1X19389,TB2HN1119227	AD626AR16N1H20260, AD626AR13N1H21849, AD626AR17N1H21594, AD626AR1XN1H20133
AD626AR17N1H21594	TB2HN1520008,TB2HN1X19238	AD626AR16N1H20260, AD626AR13N1H21849, AD626AR17N1H21594, AD626AR1XN1H20133
AD626AR1XN1H20133	TB2HN1119227,TB2HN1X19238	AD626AR16N1H20260, AD626AR13N1H21849, AD626AR17N1H21594, AD626AR1XN1H20133

[binuacs]

@puja123p one way of doing this