Shulou(Shulou.com)06/01 Report--

1. Oracle database: (note: tableName.id refers to the primary key of tableName)

Select * from

(select tableName.*,rownum as con from tableName

Where rownum = n

2. SQLServer database: (note: tableName.id refers to the primary key of tableName)

The implementation principle explains:

1) find out the previous m noodle record first.

2) find out the first n noodle record again

3) finally, filter out the first m records through conditions.

Method 1:

Select top n-m+1 * from tableName

Where tableName.id not in

(select top m tableName.id from tableName order by desc tableName.id)

Order by tableName.id

Method 2:

Select top n-m+1 * from tableName as a where not exists

(select * from

(select top m * from tableName order by id desc) b

Where b.id = a.id)

Order by id desc

3. MySQL database:

Select * from tableName limit m, n

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.