Hi! I will really appreciate help. Please take a look at few rows of one table .
MBRNO Readmit READMIT DATE READMIT Readmit
Seq. NO DISCHARGE date NO. of
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 either 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. Thanks a lot.