摘要:
select * from ryda a where a.id||a.ryid in ( select max(b.id)||b.ryid from ryda b group by b.ryid)
阅读全文
摘要:
SELECT * FROM (SELECT ROWNUM ro, TCQBM,grbh,xm,zjlx,zjhm,xzlxdm,rycbztdm,cbksrq,cbzzrq,tcqmc FROM cbrcbxx) WHERE ro>=300000 AND ro<600000
阅读全文
摘要:
复制表结构:create table tab_target as select * from table where 1=0复制表结构保留数据:create table tab_target as select * from table where 1=1
阅读全文