SQL Server Performance

Query Help

Discussion in 'T-SQL Performance Tuning for Developers' started by rupeshjs, Oct 12, 2006.

  1. rupeshjs New Member

    My SQL Table has only three columns.
    (Order, Comment, DT_LOGGED)

    ORDERComment DT_LOGGED
    1Comments A 10/11/2006
    1Comments B 10/10/2006
    1Comments C 10/09/2006
    2Comments D 10/11/2006
    2Comments E 10/10/2006
    2Comments F 10/09/2006

    I want to select latest comments logged for each order. Output would look like,

    ORDERComment DT_LOGGED
    1Comments A10/11/2006
    2Comments D10/11/2006

    I tried several syntax but of no help.

    Thanks for your help.

    Regards
  2. FrankKalis Moderator

Share This Page