Selecting a variable no. of Table Rows
I have a Table that is listing product details e.g NAME; PRICE; QUANTITY.
I want to select the row which has the 3rd lowest price. Now the Problem is that the 3rd(value) is not static but dynamic i.e. its variable and is known at runtime of the application and is specified by the user.
Is there any way of selecting or filtering out a specified row by means of 4the lowest or 3rd lowest value of column in a table.
I am trying it out for quiet some time but unfortunately with no success.