var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get Count of Different Columns in a Table
i want get the count of two different columns in same table using different where clauses.
Id Name Converted ConvertedId
1 a TRUE 1
2 aa TRUE 2
3 aaa TRUE 3
4 aaaa TRUE Null
Id Employee Id Department Id
1 1 1
2 2 1
3 3 1
4 4 1
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
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.
Currently am using two different queries to get that result..now i want to make get that result in one query...
Show us what you tried. Its easy to do but we don't do homework, however we will help
You do not need a parachute to skydive. You only need a parachute to skydive twice.