w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
How to find duplicate rows with similar part of string

Can you try this.

SELECT count(id),name
  FROM birds_name
 group by name
having count(id) >1

Thanks

SQL Fiddle





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.