[thelist] SQL Most/Count Query

Rob Smith rob.smith at THERMON.com
Thu Nov 14 13:17:01 CST 2002


Ok, try this one on for size,

terms   | other stuff
---------------------
cow     | irrelevant to this posting
cow     |  "
horse   |  "
cat     |
cat     |
cow     |
horse   |
dog     |
pig     |
pig     |
piggy   |
cats    |
cats-2  |

I want to group all entries by name, count them up by similarity, and have
one item per group of similar/like items shown with the count of
similar/like items next to them.

:-\

Thanks to who can contribute,

Rob



More information about the thelist mailing list