i write a code in
servlet which retrieve data from the data base like mysql and display the results.at a time it display 15 record.i use link like show next and it display the next 15 records.if i am in a page that display 45-60 records i make a link to backword but it display the intial 15 records.how i make a link that display records from 30-45.means the immediate previous page.what'll be sql query for that.