是关于分页的,取tblitemmaster的第181到200条数据
select * from (select rownum id, a.* from (select * from tblitemmaster order by itm_Code) a where rownum<=200) where id>=181放在TQuery中执行老是出错!
select * from (select rownum id, a.* from (select * from tblitemmaster order by itm_Code) a where rownum<=200) where id>=181放在TQuery中执行老是出错!
and rownum>=181这样可以吗?
select * from (select rownum id, a.* from
(select * from table_fj order by id0000) a where rownum<=3)
where id>=2;上面语句可以执行。
错误针对你的大概是field id0000) not found
( select rownum id, a.* from
(select * from tblitemmaster order by itm_Code) a
where rownum<=200)
where id>=181不是DELPHI问题,你的SQL有问题,在SQL-plus里可以运行么?
这样方便阅读一点,一你的A表不是物理存在的表如何用rownum呢?
将tblitemmaster换成你的表名, itm_code换成你的主键
(select rownum id, a.* from
(select * from tblitemmaster order by itm_Code) a
where rownum<=200) F<---加上一个F别名就行了
where id>=181
问题?