Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sybase sql for paging
172 views
Skip to first unread message
tungu...@gmail.com
Jan 25, 2013, 12:30:15 PM1/25/13
to
We use TOP command and ORDER_BY to implement paging for our application with Sybase database: select TOP 100 id, name from tableA order by id The problem is when add join tables, we start to receive duplicate "id" and hence the total record is less than expected (because one row on the main table can match many rows in child table). Anybody has a solution for this?
My query:
select TOP 100 a.id, a.name, b.name, c.name
from tableA a
left outer join tableB b on a.id = b.id
left outer join tableC c on a.id = c.id
where a.id < pass_in_id order by a.id desc
My query:
select TOP 100 a.id, a.name, b.name, c.name
from tableA a
left outer join tableB b on a.id = b.id
left outer join tableC c on a.id = c.id
where a.id < pass_in_id order by a.id desc
0 new messages