IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Need a db2 query asap..



IBM's flagship relational database management system
Post a reply

Need a db2 query asap..

Postby mukesh.py » Tue Jul 21, 2009 11:23 am

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
 
Posts: 8
Joined: Tue Nov 11, 2008 10:11 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Need a db2 query asap..

Postby mukesh.py » Tue Jul 21, 2009 11:25 am

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
 
Posts: 8
Joined: Tue Nov 11, 2008 10:11 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Need a db2 query asap..

Postby mukesh.py » Tue Jul 21, 2009 12:08 pm

Requirement is met. Ok to close this thread....
mukesh.py
 
Posts: 8
Joined: Tue Nov 11, 2008 10:11 pm
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks