Phil Rhoades wrote:
People,I want to select from a table ONLY unique records ie if a column has values: 1 2 3 3 4 5 I want ONLY these records returned: 1 2 4 5
SELECT count(*) as cnt,a,b,c FORM yourtable GROUP BY a,b,c HAVING cnt=1 should do. Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
