I need to search **Magento 2** DB for **duplicate SKUs** and remove duplicate products using a script, i found a very useful script here: 
[Remove duplicated products from catalog][1].<br><br>
but it's not compatible with <b>Magento 2</b> as Mag 2 is not using Mage class or `Mage.php`<br><br>
can someone please convert following code to a Magento 2 version:<br><br>

    <?php
    include 'app/Mage.php';
    Mage::app();
    
    Mage::register('isSecureArea', 1);
    
    $limit    = 100;
    $model    = Mage::getModel('catalog/product');
    $resource = $model->getResource();
    $adapter  = $resource->getReadConnection();
    $name     = $resource->getAttribute('sku');
    
    // retrieve a list of all products that have more than 1 occurrence of the same name
    $select = $adapter->select()->from(
        $name->getBackendTable(),
        array(
            $resource->getIdFieldName(),
            'value',
            'count'      => 'COUNT(*)',
            'entity_ids' => new Zend_Db_Expr("GROUP_CONCAT({$resource->getIdFieldName()})")
        )
    );
    $select->where('attribute_id = ?', $name->getAttributeId());
    $select->where('entity_type_id = ?', $name->getEntityTypeId());
    $select->group('value');
    $select->having('count > 1');
    $select->limit($limit);
    $result = $adapter->fetchAll($select);
    
    // here, we remove the lowest product id from each set of duplicate-named products. 
    // the theory is that the product which was created first, hence the lowest 
    // product id, is the one you want to keep
    $result = array_map(
        function ($row) {
            $entityIds = explode(',', $row['entity_ids']);
            $min       = min($entityIds);
            $key       = array_search($min, $entityIds);
            unset($entityIds[$key]);
            $row['entity_ids'] = $entityIds;
    
            return $row;
        },
        $result
    );
    
    // now that we have narrowed down to the ids of the products we want to delete, 
    // lets get all product ids to delete into a single array
    $entityIds = array();
    foreach ($result as $row) {
        $entityIds = array_merge($entityIds, $row['entity_ids']);
    }
    
    // lets delete each one individually
    $collection = $model->getCollection();
    $collection->addFieldToFilter($resource->getIdFieldName(), array('in' => $entityIds));
    foreach ($collection as $product) {
        $product->delete();
    }
    ?>

  [1]: https://magento.stackexchange.com/questions/115471/remove-duplicated-products-from-catalog