Sergey Gigoyan <sergey.gigoyan@gmail.com> hat am 12. Februar 2013 um 08:05
geschrieben:
> 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
select id, name, ..., row_number() over () from ...
works since 8.4.
Andreas