Pogledajte određenu poruku
Staro 25. 08. 2008.   #8
tokajac
član
Na probnom radu
 
Datum učlanjenja: 21.05.2007
Poruke: 30
Hvala: 0
0 "Hvala" u 0 poruka
tokajac is on a distinguished road
Pošaljite poruku preko Skype™ za tokajac
Default

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
tokajac je offline   Odgovorite uz citat