Help creating a query - SQL

[Antra]

Hi,

I need to get data from SQL table where column ID3 data repeats at least 2 times and column ID data starts with different letters.

In column ID there are many identifiers, but they all starts with 2 letters, as example AB and LC.

In example you can see Table1 where all data appears and Table2 how result should look.

 

Any ideas how SQL code could look to get the result?

[niche]

https://www.w3schools.com/sql/sql_select_into.asp

Looks like a simple SELECT INTO will do the trick.

Add a GROUP BY if you want to suppress duplication in id3