The problem of sql statement, everyone helps to see.

opengl_lqf

select title, count (*) as c, defaultpicurl from PE_article where articleid> = 122580 and articleid <= 123583 and deleted <>-2 group by title having count (*)> 1
Microsoft OLE DB Provider for SQL Server error '80040e14'

The column 'PE_article.DefaultPicUrl' is not valid in the select list because the column is neither included in the aggregate function nor in the GROUP BY clause.

How to change this, I do n’t want to use defaultpicurl in group by
But I want to be able to read the value of the defaultpicurl field.

shenmue024

How to change this, I do n’t want to use defaultpicurl in group by
But I want to be able to read the value of the defaultpicurl field.
=============

how can that be?

opengl_lqf

rs.open "select title, count (*) as c from PE_article where articleid> = 122580 and articleid <= 123583 and deleted <>-2 group by title having count (*)> 1", conn, 1,1
 
This is reading the title field with duplicate records.
Now when I read the record, I can use rs ("title") to get the value of this field.
Can I also read the value of another field using rs ("aabc")? Can't this be achieved?

shenmue024

No, if you add a field, you must press this field
group by.

shenmue024

for example:
Title defaultpicurl
A 11
A 22

If you just press TITLE group by, you also want to display the defaultpicurl

Does it show 11 or 22?

疾风劲草

The columns specified in the group by clause must be included in the select list

klongvv

It's not easy to write code so late. . .

疾风劲草

I'm used to it. I can't sleep early now.

opengl_lqf

Then there is no way.

lisongfox

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