i have an sql query which return huge results(about milion recods) and i want to print it in html browser. How can i use sql for paging so that i can retrieve first 100 results ,the next 100 results..and so on........

----------------------
suresh