SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed



Hosting by DigitalOcean

Support ST on Ko-Fi

Live
Down to Post
Backboards: 
Posts: 157
In response to "SELECT lastname, COUNT(name) as freq FROM table GROUP BY lastname ORDER BY freq ASC. Then take the first result. -- nm" by kilboooo

Yeah, I think this is about where I'm getting. Infortunately, I have to nest the above in another query.

Posted by JaxSean (aka JaxSean) Oct 28 '08, 07:14
it's getting a bit complex and was hoping there was a function (like COUNT) that I wasn't thinking of.

Responses:
Post a message   top
Replies are disabled on threads older than 7 days.
(Disclaimer: This website uses cookies to store identifying information. Please practice safe password usage.)