两个问题一起问拉

[gagaxiaoyuer]

1.
SELECT * FROM power_meter a
where FGENERAL_NO in
(select FGENERAL_NO from power_meter where FCONCENTRATOR_NO=a.FCONCENTRATOR_NO group by FGENERAL_NO having count(*)>1)
order by FGENERAL_NO
我想取出FGENERAL_NO这列的后面四位相同

2.SELECT FMTR_ID,FGENERAL_NO,FCONCENTRATOR_NO FROM POWER_METER
WHERE
我想取后 FMTR_ID 和 FGENERAL_NO 这两列后面6位相同的数据

[playwarcraft]

不懂，還是貼數據來的實在

[dawugui]

1.
SELECT * FROM power_meter a
where right(FGENERAL_NO,4) in
(select right(FGENERAL_NO,4) FGENERAL_NO from power_meter where FCONCENTRATOR_NO=a.FCONCENTRATOR_NO group by right(FGENERAL_NO,4) having count(*)> 1)
order by FGENERAL_NO

[dawugui]

2.
SELECT FMTR_ID FMTR_ID,FGENERAL_NO,FCONCENTRATOR_NO FROM POWER_METER right(FMTR_ID,6) = right(FGENERAL_NO,6)

[pt1314917]

--这样？
SELECT * FROM power_meter a 
where right(FGENERAL_NO,4) in 
(select right(FGENERAL_NO,4) from power_meter where FCONCENTRATOR_NO=a.FCONCENTRATOR_NO 
group by right(FGENERAL_NO,4) having count(*)> 1) 
order by FGENERAL_NO 


SELECT FMTR_ID,FGENERAL_NO,FCONCENTRATOR_NO FROM POWER_METER  
WHERE  right(FMTR_ID,6)=right(FGENERAL_NO,6)

[dawugui]

1.
SELECT * FROM power_meter a
where right(FGENERAL_NO,4) in
(select right(FGENERAL_NO,4) FGENERAL_NO from power_meter group by right(FGENERAL_NO,4) having count(*)> 1)
order by FGENERAL_NO

第一个不需要表连接.

[gagaxiaoyuer]

谢拉 已经快解决拉 我是需要FCONCENTRATOR_NO=a.FCONCENTRATOR_NO 这个相同

[gagaxiaoyuer]

但是为什么数据不出来 假如 有的



FMTR_ID FGENERAL_NO
TDL012999 00812999



按道理这数据要出来 但是为什么没出来