Kod: Tümünü seç
select stokkodu,stokadi from stok where stokkodu in (select stokkodu from stok group by stokkodu having count(stokkodu)>1) ORDER BY STOKKODU
veritabanı firebird.
Kod: Tümünü seç
select stokkodu,stokadi from stok where stokkodu in (select stokkodu from stok group by stokkodu having count(stokkodu)>1) ORDER BY STOKKODU
Kod: Tümünü seç
delete from stok where not ID in (select min(ID) from stok group by stokkodu)