Kolicina podataka je prilicno velika tako da bi dobro doslo da se jos na nivou SQL odaberu samo potrebne n-torke.
Dosada sam prokljuvio nesto ovako:
Code:
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
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
OK je, za prvih nekoliko stranica, ali sta se dogadja kod iscitavanja poslednje stranice?
Da li ima jos ideja na ovu temu?
Pozdrav
P.S.
Probao sam sa
Code:
rownumber() OVER
(ORDER BY booking_id)
AS ROW_NEXT
rownumber() OVER
(ORDER BY booking_id)
AS ROW_NEXT
ali nisam useo da nateram rownumber() da radi. Jer ne postoji takva funkcija?