| Subject | Re: [firebird-support] SELECT COUNT(sub_select.*) as COUNT, sub_select.user_name ... |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-01-15T12:08:34Z |
At 11:14 AM 15/01/2004 +0100, you wrote:
Weird kinda output spec. I'm curious about what its use is...
/hb
>Hi,Then he won't get the full count.
>
>Firebird doesn't support "derived tables" (that's what
>you're doing, not a "subselect").
>
>Why not simply use:
>
>select count(*), user_name
>from user
>group by user_name
Weird kinda output spec. I'm curious about what its use is...
/hb