sum(refcount)
from tableName
group by refkeywords
order by sum(refcount) desc
On 15 Mar 2004 at 16:42, Che Vilnonis wrote:
>
> I have the following output from my database:
>
> refkeywordsrefcount
> -------------------
> karate korner5
> N/A3
> N/A2
> John wolf KICKBOXING2
> N/A2
> buy tabi2
>
> how would I write this as a sql query so that the
> results show up as:
>
> refkeywordsrefcount
> -------------------
> N/A7
> karate korner5
> buy tabi2
> John wolf KICKBOXING2
>
> As always, thanks in advance... Che
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
