[SQL] An example of data deletion and selection, using GROUP and DISTINCT

The problem encountered today had been resolved after a long morning. As recorded here, I think this Code can be applied to many similar problems.

Requirement Description:

A table named MyImage has the following columns: Number ID and PATH
For example:

ID PATH

1 C :/
1 C :/
1 D :/
2 C :/
2 C :/
3 :/
3 C :/
4 D :/

Write an SQL statement and return the ID number of the record: different paths exist for the same ID. In the above example, the correct result should be:

ID

1

3

(ID2 does not have different paths, and ID4 only has one record without different paths)

Here is my SQL statement:

Select ID from [MyImage] as A group by ID having (select COUNT (distinct (Path) from [MyImage] as B where B. ID = A. ID)> 1

One morning, I wrote such a sentence! Excellent! Yes!