Jump to content

Help creating a query - SQL


Antra
 Share

Recommended Posts

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?

Capture.PNG

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...