select FKUK014.DAIBUNRUICD,FKUK014.CHUBUNRUICD, MCOM011.DAIBMEI, MCOM011.CHUMEI from MCOM011,FKUK014 , (select FKUK014.DAIBUNRUICD,max(rowid) rowid from FKUK014) a where MCOM011.DAIBRCD = FKUK014.TANKYOCD AND MCOM011.CHUBRCD = FKUK014.TENPOCD and FKUK014 .rowid=a.rowid
distince是去掉重复记录,重复的记录指的是查询结果中中的每个字段的值全部相同才行
有误吧? select FKUK014.DAIBUNRUICD,FKUK014.CHUBUNRUICD, MCOM011.DAIBMEI, MCOM011.CHUMEI from MCOM011,FKUK014 , (select FKUK014.DAIBUNRUICD,max(rowid) rowid from FKUK014) a (错误处?) where MCOM011.DAIBRCD = FKUK014.TANKYOCD AND MCOM011.CHUBRCD = FKUK014.TENPOCD and FKUK014 .rowid=a.rowid 在线求助!
如果我想显示如下的结果该存储过程该如何写? 1 2 3 4 -------对应的列 1232 1232 sha sha wo go 2121 1111 wdwdws ds 在线求助!
1. 分辨不清你的原始数据.2. distinct只能保证查询出的整个组没有重复记录, 里面的个别字段没办法处理.3. 可以是同max/min() over (partition by col1,col2,..)的分析函数将个别字段的重复记录剔除出来^_^
1232 1232 sha sha wo go
2121 1111 wdwdw sds
(select FKUK014.DAIBUNRUICD,max(rowid) rowid from FKUK014) a
where MCOM011.DAIBRCD = FKUK014.TANKYOCD AND MCOM011.CHUBRCD = FKUK014.TENPOCD and FKUK014 .rowid=a.rowid
select FKUK014.DAIBUNRUICD,FKUK014.CHUBUNRUICD, MCOM011.DAIBMEI, MCOM011.CHUMEI from MCOM011,FKUK014 ,
(select FKUK014.DAIBUNRUICD,max(rowid) rowid from FKUK014) a (错误处?)
where MCOM011.DAIBRCD = FKUK014.TANKYOCD AND MCOM011.CHUBRCD = FKUK014.TENPOCD and FKUK014 .rowid=a.rowid
在线求助!
1232 1232 sha sha wo go
2121 1111 wdwdws ds
在线求助!