mislim da je funkcija row_number() a ne rownumber()
Kôd:
SELECT * FROM (
SELECT booking_id, row_number() OVER (ORDER BY booking_id) AS ROW_NEXT
FROM bookings
) AS tmp
WHERE ROW_NEXT BETWEEN 21 and 40
__________________
We professional we dealin' with business
Poslednja izmena od japan : 19. 08. 2008. u 12:54.
|