How to customize dataprovider in cgridview in yii
I have a query to find duplicate as:
SELECT *
FROM tbl_normalized_data_view y
INNER JOIN (SELECT column_1, column_2, COUNT(1) AS CountOf
FROM tbl_normalized_data_view
GROUP BY column_1, column_2
HAVING COUNT(1)>1 ) dt
ON y.column_1=dt.column_1 and y.column_2=dt.column_2
now I want to show only records that contain the data of above stated
query, SO please guide me how to use data provider for this purpose.
No comments:
Post a Comment