How can I query a table based on row numbers?


  • select numberofmonths  from traveldays_president where row_number= 55;

    How can I go about filtering records based on row number?

    Friday, March 28, 2014 6:34 PM


  • Use a query like

    select numberofmonths  from traveldays_president where row_number=@rownumber

    Create a dataset with above query in SSRS and on refreshing it after execution SSRS will add field information and parameter information for you. Then when you try to run report it will ask you for value of rownumber and based on value you pass it will give you corresponding row(s) in output

    Please Mark This As Answer if it helps to solve the issue Visakh ----------------------------

    Friday, March 28, 2014 6:37 PM