CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Mo786

Search: Search took 0.10 seconds.

  1. March 4th, 2013, 10:05 AM

    Thread: SQL Server COUNT query with unique values.

    by Mo786
    Replies
    2
    Views
    2,128

    Re: SQL Server COUNT query with unique values.

    Never mind, I found the answer.

    select organization, moneyamount,
    moneyamount / count(*) over (partition by organization)
    from t
  2. March 1st, 2013, 11:40 AM

    Thread: SQL Server COUNT query with unique values.

    by Mo786
    Replies
    2
    Views
    2,128

    SQL Server COUNT query with unique values.

    This is done in Microsoft SQL Server 2008 R2.

    I'll start out with an example table.


    Organization | MoneyAmount | MoneyAmountAvg

    ISD | 500 |
    ISD ...
Results 1 to 2 of 2





Click Here to Expand Forum to Full Width

Featured