i have a table which have code col and data col.the code and data occur repeated no of time.
so i run query like
SELECT code, COUNT( code ) AS no_of_times
GROUP BY code
ORDER BY code
which give no of time code is repeated in the table but i also wants the data corresponding to code to be concated and shown in different col.
i need query for this