IBM Mainframe Forum

[mukesh.py]

Hi 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...

[mukesh.py]

that is for a single day more 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 hence all the scenario shud be selected......

[mukesh.py]

Requirement is met. Ok to close this thread....