Hi,
I have a scenario where user provided a comma separated string like 'amit,sanjay,sumit' and I want to match where each comma separated value is subset of another data in table.
For e.g.
Table 1
Sl.No ColumnName
1. sumit,sanjay,amit,ajay
2. amit,sumit,sanjay
3. amit,sumit,akshay
I want a query which would return Sl.No 1 and 2 as 'amit,sanjay,sumit' is exists in those two rows and not on the third row.