Renders a paged SELECT statement
Generated SQL statement
Generating pagination SQL is different on different databases because every database offers different levels of support for such functioanality. Some databases (SqlServer 2000) require the programmer to supply the total number of rows to produce a page. If your renderer does not use the totalRowCount parameter, please state so in your implementation documentation.