Re: SELECT only non-identical values

2001-03-08 Thread Jason Landry
select distinct item from $table It sounds like you might want to read up a little on normalization, however. > I would like to modify the following statement > > select Item from $table > > in such a way that it checks what kinds different items are in the database. Hence, only those values sh

SELECT only non-identical values

2001-03-08 Thread daszimmer
I would like to modify the following statement select Item from $table in such a way that it checks what kinds different items are in the database. Hence, only those values should be returned, which are not identical to each other. Example: Apple (5 occurances), Apple-Pie (3 occurances), Pumpk