An example of deleting selected data is parsed using GROUP and DISTINCT instances.

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:
Copy codeThe Code is as follows:
Select ID from [MyImage] as
Group by ID
Having
(
Select COUNT (distinct (Path) from [MyImage] as B where B. ID = A. ID
)
> 1