1.I am using stored procedure to implement the pagination.when i change the "order by" class from the front end ...i have to retrive the data first by "Order by the field" and then the where class.

2.Can any one help me how we can implement the pagination in Stored
procedures.the basic requirement is that the Order BY class " changes as and when...required.

Advices on this is appreciated.