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
hi,
please see this code
select aiah_number.aiah_number_id, aiah_number.aiah_number,
lock.lock_status, rank.rank_value, approve.approve_status, lock.view
from aiah_number inner join lock on aiah_number.locked = lock.lock_id
inner join rank on aiah_number.rank = rank.rank_id inner join approve
