Search found 1 match
- Fri Apr 15, 2016 10:09 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Db2 SQL Query
- Replies: 0
- Views: 5256
Db2 SQL Query
I am looking for a SQL query for the scenario: " I need all the card numbers (CARD_NUM) with duplicate entries in table "CC_DETAILS" with overlapping dates for PAID and INCUR dates. Example: CARD_NUM CHAR 12 767000411349 PAID_BGN_DT DATE 10 2014-01-01 PAID_END_DT DATE 10 2017-01-01 INCUR_BGN_DT DATE...