***********************************************
select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT('\'',`RIGHT_CODE','\'')as right_code
FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC`
HAVING count( `RIGHT_CODE` ) >=2
****************************************************
Actually the above query returns empty result.
But the query Inside IN cluase which returns ('1','28')..
If i directly pass the value inside IN clause means it returns a result,
for example:
select * from table_name where RIGHT_CODE IN ('1','28');
Is there any other way to overcome this issue please let me know..