|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Group by AND order by. |
|
From: |
Stian |
|
Date: |
7/19/2000 3:06:31 PM |
|
IP: |
212.242.58.62 |
My problem:
I have a access-database width a lot of data.
This is a forum.
Now I want to count how many times each person has written in it.
I use:
"SELECT name, COUNT(*) AS number FROM table GROUP BY name"
This will give a list in alphabetic order.
I want this list to be "order by number" , so the most "active" person is at the top of the list !..
Can anybody help me ??? |
Follow Up - Re: Group by AND order by. - Casey Choi 7/20/2000 6:43:06 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
