[tokajac]

Sta kazete za ovako nesto?

        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