The problem of sql statement, everyone helps to see.

slayer_ghost

select title, defaultpicurl, count (*) as c from PE_article where articleid> = 122580 and articleid <= 123583 and deleted <>-2 group by title having count (*)> 1 order by title, defaultpicurl

yfacmilan

No way, do not use aggregation, or not in group by, or do not use

The landlord wants to know that it can't be achieved
If there are 3 records with the same title but different defaultpicurls, one record will eventually be created by group. Which value of defaultpicurl should be taken for this record?