ST Alpha - "SELECT lastname, COUNT(name) as freq FROM table GROUP BY lastname ORDER BY freq ASC. Then take the first result. -- nm" (Reading a Post)

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

Down to Post

Backboards:

Posts: 157

In response to "SQL question: is there a function that finds the [item] that shows up the most in a query?" by JaxSean

SELECT lastname, COUNT(name) as freq FROM table GROUP BY lastname ORDER BY freq ASC. Then take the first result. -- nm

Posted by kilboooo (aka kkuphal) Oct 28 '08, 07:08

(No message)

Responses:

Yeah, I think this is about where I'm getting. Infortunately, I have to nest the above in another query. - JaxSean Oct 28, 07:14 2
- that would have been ORDER BY freq DESC also (it's too early). What's the other query? -- nm - kilboooo Oct 28, 07:15 1
  - here's the whole thing: - JaxSean Oct 28, 07:24
sorry, that's COUNT(lastname) -- nm - kilboooo Oct 28, 07:11

Post a message top

Replies are disabled on threads older than 7 days.