Dijkgraaf - 4:17 am on Sep 26, 2012 (gmt 0)

bortherhood of LAN is right in principle, but wrong in detail ;-), if you want to be distinct on cemailid you need to group on cemailid

SELECT select cemailid, cno,cfname,cphone
FROM rform
GROUP BY cemailid