Subject | Re: SELECT COUNT(sub_select.*) as COUNT, sub_select.user_name ... |
---|---|
Author | esrefatak |
Post date | 2004-01-15T12:28:13Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
the "full set count in every row". really...
wrote:
> At 11:57 AM 15/01/2004 +0000, you wrote:in
>
> > > 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
> every row?require to record paging. My English speaking is bad. But, require
>
> /hb
the "full set count in every row". really...