Sta kazete za ovako nesto?
Kôd:
SELECT *
FROM
(
SELECT * FROM
BFWBBBKS b
left outer join BFWBBCLS c on b.COLID=c.COLID
left outer join BFWBBCLA ca on ca.COLADRID=b.COLADRID
left outer join BFWBBCTP ct on ct.CARTPID = b.CARTPID
left outer join BFWBBCAR car on car.CARID =b.CARID
left outer join BFWBBSTS bs on bs.BOOKSTSID = b.BOOKSTSID
left outer join BFWBBUSR cu on CAST(b.CRTUSRID AS INTEGER) = cu.WBBUSERID
left outer join BFWBBUSR uu on CAST(b.UPDBUSRID AS INTEGER) = uu.WBBUSERID
order by b.WBBBOOKID
FETCH FIRST 20 ROWS ONLY
) AS bo
order by WBBBOOKID desc
FETCH FIRST 20 ROWS ONLY
Kontam da je cool za prve stranice, ali sta se dogadja kod iscitavanja poslednje stranice ukoliko imam preko 1000 redova?
Pozdrav