Need a db2 query asap..
Posted: Tue Jul 21, 2009 11:23 amHi all.... please let me know the db2 query for the below requirement..
Table Name : CHECK
where claim_num_cd = 12345
and check_dt for a particular day > 10
that is for a single day for than 10 checks are issued for a particular claim......
since we have 230 rows total for this claim.. we can have more than one scenario where check issued for a particular day > 10 and hance all the scenario shud be selected......
Thanks...
Table Name : CHECK
where claim_num_cd = 12345
and check_dt for a particular day > 10
that is for a single day for than 10 checks are issued for a particular claim......
since we have 230 rows total for this claim.. we can have more than one scenario where check issued for a particular day > 10 and hance all the scenario shud be selected......
Thanks...