Pogledajte određenu poruku
Staro 18. 08. 2008.   #3
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

Evo primera:

Kôd:
SELECT * FROM (
  SELECT booking_id    
    rownumber() OVER
     (ORDER BY booking_id)
     AS ROW_NEXT 
    FROM bookings 
  )
AS tmp WHERE 
ROW_NEXT BETWEEN 21 and 40

Kôd:
[SQL0104] Token ( was not valid. Valid tokens: , FROM INTO. Cause.....:A syntax error was detected at token (.

Pozdrav
tokajac je offline   Odgovorite uz citat