Calculation at database level
Hi! Please take a look at few rows of one table .
MBRNO Readmit READMIT DATE READMIT Readmit
Seq. NO DISCHARGE date NO. of days
121 1 20030101 20030105 5
2 20030105 20030115 10
3 20030202 20030218 3
4 20030218 20020220 0
The measure is count of cases. I do not want to calculate the case with readmit no of days = '0'. Also, discharge date of seq # 1 is same as readmit date of seq # 2. So I need to count first or 2nd row. So actual count of cases for this member is 2 ( though it appears as 4). How will I achieve it at database level? I will appreciate the help.
Software/Hardware used:
Software/Hardware used:
ASKED:
June 11, 2005 3:47 PM
UPDATED:
June 13, 2005 12:47 AM
Answer Wiki:
Hi,
You will have to specify that condition in the "Having" clause of the select statement.
Prashanth.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
