查询 FGENERAL_NO 这列大于一的记录 还有个要求是 FCONCENTRATOR_OLD这列的值相等 应该怎么写?
SELECT * FROM power_meter
where FGENERAL_NO in(select FGENERAL_NO from power_meter group by FGENERAL_NO having count(*)>1) order by FGENERAL_NO
...全文
8717打赏收藏
求SQL语句4
查询 FGENERAL_NO 这列大于一的记录 还有个要求是 FCONCENTRATOR_OLD这列的值相等 应该怎么写? SELECT * FROM power_meter where FGENERAL_NO in(select FGENERAL_NO from power_meter group by FGENERAL_NO having count(*)>1) order by FGENERAL_NO
SELECT * FROM power_meter a
where FGENERAL_NO in(select FGENERAL_NO
from power_meter where FCONCENTRATOR_OLD=a.FCONCENTRATOR_OLD group by FGENERAL_NO having count(*)> 1) order by FGENERAL_NO
SELECT * FROM power_meter a
where FGENERAL_NO in(select FGENERAL_NO
from power_meter where FGENERAL_NO=a.FGENERAL_NO group by FGENERAL_NO having count(*)> 1) order by FGENERAL_NO