Advanced Search

Return to Snippet

Revision: 10106
at December 8, 2008 11:39 by flatearthcomms
Initial Code 
SELECT DISTINCT(email), newsletter FROM contact_tbl WHERE newsletter != 0;

SELECT email, newsletter FROM contact_tbl WHERE newsletter != 0 GROUP BY email;
Initial URL 









Initial Description





DISTINCT will produce more results if a user had been added with more than one type of newsletter. The GROUP BY clause will just get the single email.









Initial Title





Selecting only one occurrence from a column









Initial Tags














Initial Language





SQL