select aiah_number.aiah_number_id, aiah_number.aiah_number,
...
order by rank_value desc limit 1 offset 1;
I use:
==
select ...
order by ...
LIMIT #{pageSize}::INTEGER OFFSET #{offset}::INTEGER;
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make
On 2011-06-17, hatem gamal elzanaty wrote:
> hi,
> please see this code
>
> select aiah_number.aiah_number_id, aiah_number.aiah_number,
...
> order by rank_value desc limit 1 offset 0;
>
> and this code
>
> select aiah_number.aiah_number_id, aiah_number.aiah_number,
...
> order by rank_value des