Re: [Gnumed-devel] Inadvertent deletion of Procedure when Deleting episode

[Karsten Hilbert]

On Thu, Aug 01, 2013 at 06:11:09PM +0000, Jim Busser wrote:

>       gnumed_v18=> SELECT pk_item
>               FROM clin.clin_root_item
>               ORDER BY pk_item
>               OFFSET (SELECT COUNT(pk_item)
>                                       FROM clin.clin_root_item)-5 ;

Perhaps easier:

        SELECT pk_item
        FROM clin.clin_root_item
        ORDER BY pk_item DESC
        LIMIT 5

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346