Subject Re: [firebird-support] Re: SELECT COUNT(sub_select.*) as COUNT, sub_select.user_name ...
Author Helen Borrie
At 11:57 AM 15/01/2004 +0000, you wrote:

> > SELECT
> > (select count(ss.user_name) from USER ss) as "COUNT",
> > u.user_name,
> > u.password
> > FROM USER u;
> >
> > /hb
>
>it method is lower performance

..lower performance than what?

Out of curiosity, why do you need a set that has the full set count in
every row?

/hb