|
abcd
Yak Posting Veteran
92 Posts |
 Posted - 11/28/2008 : 02:00:36
|
my problem is as follows....
i am having a result set containing columns
userid,
deptname,
leavetype,
ismispunched,
where leave type can be of three categories
normal,on duty and on tour
now i want to display userid,deptname and in seperate columns how many times user went on -on duty,normal or was on tour
basically problem is how to compare column value in a table with a given criteria and display it in a seperate column
|
|
urgent help
