RowNumber().how to set a range inbetween a current date record using rownumber()?

Discussion in 'Programming' started by AhWoon92, Jun 3, 2012.

0
  1. #1
    I have "Previous" button and " Next Button"i want to show current day record after i open the sceen. then when i click previous, it will show past records and when click next, it will show future booking records.i stuck at this query and i know i nearly there but i need a guide.Select * From ( Select *, ROW_NUMBER() Over (Order By BOOKING_FROM_DATETIME) As RowNum From ROOM_BOOKING ) As MyDerivedTable
     
    AhWoon92, Jun 3, 2012 IP