Display blob field with aggregate function?

Posted on 2011-10-26
Last Modified: 2013-12-24
Hi All,

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, MAX(f.starttime) senddate, df. blogInfo
    FROM datafile f, datafileDetail df
     WHERE ( =
  GROUP BY, df. blogInfo

Question by:mlong219
    LVL 13

    Accepted Solution

    You could get max of the blob but you cant group on it. Or use a sub query
    select t1.*,
    (select bloginfo from filedetail where id = as info from (
    SELECT,, MAX(f.starttime) senddate
        FROM datafile f
         WHERE ( =
      GROUP BY, as t1
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now