Snitz Forums 2000 - Help with formatting

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Help with formatting

New Topic

Topic Locked

Printer Friendly

Author

Topic

SiSL
Average Member

Turkey
671 Posts

Posted - 08 February 2008 : 03:11:32

Seriously guys my brain stucks sometimes...

Just going to ask such thing, I have a table like that

ID AUTHOR MESSAGE
-------------------
1 25 LALALA
2 25 XXXX
3 30 ZZZ
4 30 YYYY
5 25 TRALALA

As a funny example

I want to pick most active authors from those... like here in this example author with authorid = 25 wrote 3 messages, authorid 30 wrote 2 messages

So I want to have such list like:
1. Author 25
2. Author 30

Which SQL statement I can do that with?

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 08 February 2008 : 04:34:17

Something like:

Select Author, Count(Id) As Messages FROM table_name Group By Author Order By Messages DESC

SiSL
Average Member

Turkey
671 Posts

Posted - 08 February 2008 : 05:07:34

Thank you so much, going to try that :)

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.27 seconds.