Home  >  Article  >  Database  >  oracle,sqlserver 2000分页查询

oracle,sqlserver 2000分页查询

WBOY
WBOYOriginal
2016-06-07 15:51:34985browse

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 前台Ext,后台ibatis 数据库分页 ORACLE: SELECT * FROM (SELECT A.* ,ROWNUM RN FROM 表名 A WHERE 字段名 LIKE ('%'||#字段名#||'%') ORDER BY $orderBy$ $orderType$) WHERE RN#start# AND RN=#st

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

  前台Ext,后台ibatis  数据库分页

  ORACLE:

  SELECT * FROM (SELECT  A.* ,ROWNUM RN FROM 表名 A WHERE  字段名 LIKE ('%'||#字段名#||'%') ORDER BY $orderBy$ $orderType$) WHERE RN>#start# AND RN

  SQLSERVER 2000:

  select top $limit$ * FROM 表名 WHERE id not in(SELECT TOP $start$ id FROM 表名 ORDER BY $orderBy$ $orderType$) ORDER BY $orderBy$ $orderType$

oracle,sqlserver 2000分页查询

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn