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';