ST Alpha - "SQL question: is there a function that finds the [item] that shows up the most in a query?" (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

SQL question: is there a function that finds the [item] that shows up the most in a query?

Posted by JaxSean (aka JaxSean) Oct 28 '08, 06:52

for example, you have a dataset of 100,000 with names in it. I want to find the last name that appears the most. Is there some function?

tia

Responses:

SELECT lastname, COUNT(name) as freq FROM table GROUP BY lastname ORDER BY freq ASC. Then take the first result. -- nm - kilboooo Oct 28, 07:08 4
- 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
i don't think so -- nm - decline Oct 28, 07:03

Post a message top

Replies are disabled on threads older than 7 days.