Re: Row Count - Mailing list pgsql-novice

Sergey Gigoyan, 12.02.2013 08:05:
> How can I get selected row count in one statement?
> For example, I can do that by two select statements
>
> select id, name, addrress, (select count(*) from(select id
>                                                                       from users
>                                                                        where name<>'examplename')
> from users
> where name<>'examplename'
>

select id,
        name,
        addrress,
        count(*) over () as row_count
from users
where name <> 'examplename';