Page is a not externally linkable
- Code, Content, and Presentation
---- MySQL - How to get DISTINCT or UNIQUE ?
Dijkgraaf - 4:17 am on Sep 26, 2012 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4488531.htm
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
GROUP BY cemailid
Brought to you by WebmasterWorld: http://www.webmasterworld.com