009 Medical Project-Module one: implementation of user query paging list

This project is using the Oracle database, so we use the Oracle paging method.

The paging query syntax for Oracle:

Example: Querying the 20th to 30th piece of data

Regular paging statements:

Select page_table. *  from (Select  sysuser.  *fromwhere rownum<=) page_tablewhere Page_ Table.page_number>

Query Result:

But the SQL statement above is not extensible, so write an easy-to-extend SQL statement:

From (

Select Page_table1.*,rownum Page_num from (


//

Any query statements can be added between//...//

where page_table2.page_num>20

The result of the query is the same.

However, the above-mentioned wording, the universality is even better, whether you want to query what to achieve paging can be used directly. can be directly in/////between any query statements, query structure can be directly according to your requirements

To achieve paging. This is a unified approach.

009 Medical Project-Module one: implementation of user query paging list