select min(id), plantName ,stagingName FROM
(SELECT id, plantName ,stagingName FROM fa_winderturbine_lists
WHERE `companyName` = '新能源四川公司' AND `plantname` = '火烈风电场'
)as ta
group by stagingName
#这是生成相同记录最小的行
从表1 生成表2 再生成表3
select min(id), plantName ,stagingName FROM
(SELECT id, plantName ,stagingName FROM fa_winderturbine_lists
WHERE `companyName` = '新能源四川公司' AND `plantname` = '火烈风电场'
)as ta
group by stagingName
#这是生成相同记录最小的行
从表1 生成表2 再生成表3