Home Forums SQL Server 2008 SQL Server 2008 - General Sum with Multi Category and Group By Acc No ? RE: Sum with Multi Category and Group By Acc No ?

  • September 19, 2012 at 6:54 am

    #1539525

    ChrisM@Work (9/19/2012)

    chinye2020 (9/19/2012)

    i mean select the top 1 Amount in the sql query

    Ordered by what? Amount? Transaction date?

    all Sum will according the TrasnType_ID and Acc No, so Result will show the all Acc No and their TransType Total Amount,

    and i just want in the Tbl_Transaction where is Top 1 Amount and show the Top 1 Amount as Opening_Balance, that's all