Display blob field with aggregate function?
Posted on 2011-10-26
I need to create a query that will display the last the time a file was sent, as well as the header info. The header info is stored in a blob data type, that basically represents a XML file. I can see the blob data without any issues, until I add the aggregate function which I need. Is there a work around for this?
I get the error mesage saying 'blog data type are not allowed in Group clause'.
SELECT f.name, MAX(f.starttime) senddate, df. blogInfo
FROM datafile f, datafileDetail df
WHERE (df.id = f.id)
GROUP BY f.name, df. blogInfo