data redundancy

some data are stored twice, or that some data can be derived from other data.

We have same issue for data redundancy.

SELECT P.P_USER_ID, COUNT(*)
FROM PURPOSE P
GROUP BY P.P_USER_ID
HAVING COUNT(*) > 1;

Example linkK

http://www.devx.com/gethelpon/10minutesolution/16597/1954