Citat:
Originalno napisao tokajac
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 |
Koliko ja vidim, tebi fali zarez iza "SELECT booking_id".
Znaci: ... SELECT booking_id, rownumber() ...
Javi je l' do zareza.
