不同的数据库不连续的取数据的语法是不同的:
oracle:
select * from (select t.*,rownum num from T_XT_ZZJG t where t.rownum<VALUE1) a where a.num>VALUE2;
select * from T_XT_ZZJG a where a.rowid in (
select b.rid
from (
select c.*,c.rowid rid,rownum rm from T_XT_ZZJG c
where rownum < 1000
) b
where b.rm > 200
);
mysql:
select * from T_XT_ZZJG t limit BEGINE_VALUE,HOW_MANY;
sql server:
SELECT TOP N * FROM MYTABLE ORDER BY ORD_COL;
sybase:
SET ROWCOUNT N
GO
SELECT * FROM TABLE1
db2:
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N