Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: Get Count of Different Columns in a Table

    Hi,

    i want get the count of two different columns in same table using different where clauses.

    for example:

    Employee
    Id Name Converted ConvertedId
    1 a TRUE 1
    2 aa TRUE 2
    3 aaa TRUE 3
    4 aaaa TRUE Null


    Members
    Id Employee Id Department Id
    1 1 1
    2 2 1
    3 3 1
    4 4 1


    Department
    Id Name
    1 Account
    2 Sales

    from the above tables i want the
    count of employee where the Converted = True,
    the count of convertedid where the convertedId is not null for the department Account.


    Thanks in Advance
    Sudhakar

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What query did you manage to produce so far? Copy it over here, and someone wll assist. It doesn't seem to be THAT complicated, so that we should post a complete solution for you.

  3. #3
    Join Date
    Aug 2011
    Posts
    2
    Currently am using two different queries to get that result..now i want to make get that result in one query...

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Show us what you tried. Its easy to do but we don't do homework, however we will help
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •