Re: Row Count

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: Sergey Gigoyan <sergey(dot)gigoyan(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Row Count
Date: 2013-02-12 08:03:02
Message-ID: 1294801499.20352.1360656182986.JavaMail.open-xchange@ox.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sergey Gigoyan <sergey(dot)gigoyan(at)gmail(dot)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

In response to

  • Row Count at 2013-02-12 07:05:20 from Sergey Gigoyan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sergey Konoplev 2013-02-12 08:07:21 Re: Row Count
Previous Message Thomas Kellerer 2013-02-12 08:00:33 Re: Row Count