Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Grouping by column value

    Ashok Suhag (3/3/2009)

    Hey Try This!

    select * from

    (

    SELECT EntityID, Property, MAX(CASE WHEN fromDeleted = 1 THEN Value END) AS OldValue,

    ...

    March 4, 2009 at 12:53 am

    #952914

  • RE: Grouping by column value

    John Marsh (3/3/2009)

    Hello,

    I think adding a Having clause to your Select statement would do the trick.

    Regards,

    John Marsh

    Hi, thanks for your reply!

    I tried this:

    HAVING (MAX(Value) >...

    March 3, 2009 at 11:28 pm

    #952882

Viewing 2 posts - 1 through 3 (of 3 total)