https://miac.volmed.org.ru/wiki/index.php?action=history&feed=atom&title=%D0%A3%D0%B4%D0%B0%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%B4%D1%83%D0%B1%D0%BB%D0%B8%D0%BA%D0%B0%D1%82%D0%BE%D0%B2Удаление дубликатов - История изменений2026-04-11T12:15:52ZИстория изменений этой страницы в викиMediaWiki 1.44.0https://miac.volmed.org.ru/wiki/index.php?title=%D0%A3%D0%B4%D0%B0%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5_%D0%B4%D1%83%D0%B1%D0%BB%D0%B8%D0%BA%D0%B0%D1%82%D0%BE%D0%B2&diff=3586&oldid=prevDmitriy: Новая страница: «<pre> SELECT * FROM [www_new].[dbo].[pok] T1, (SELECT id_pok, id_per,id_lpu,id_group,znach FROM [www_new].[dbo].[pok] GROUP BY id_pok, id_per,id_lpu,id_group,znac…»2015-05-14T09:15:11Z<p>Новая страница: «<pre> SELECT * FROM [www_new].[dbo].[pok] T1, (SELECT id_pok, id_per,id_lpu,id_group,znach FROM [www_new].[dbo].[pok] GROUP BY id_pok, id_per,id_lpu,id_group,znac…»</p>
<p><b>Новая страница</b></p><div><pre><br />
SELECT *<br />
FROM [www_new].[dbo].[pok] T1,<br />
(SELECT id_pok, id_per,id_lpu,id_group,znach FROM [www_new].[dbo].[pok]<br />
GROUP BY id_pok, id_per,id_lpu,id_group,znach<br />
HAVING COUNT(id_pok) > 1) T2<br />
WHERE T1.id_pok=T2.id_pok<br />
and T1.id_per = T2.id_per<br />
AND T1.id_lpu = T2.id_lpu<br />
AND T1.id_group = T2.id_group<br />
AND T1.znach = T2.znach<br />
order by t1.id_pok,t1.id_per,T1.id<br />
</pre><br />
<br />
копируем результат в excel, данные >> удалить дубликаты >> выбираем столбцы кроме <br />
первого id и даты, получаем записи, кот. надо удалить.<br />
<br />
<pre> delete from www_new.dbo.pok where id=3516401 </pre></div>Dmitriy