- 论坛徽章:
- 0
|
请指教
应该没问题!
Test:
- CuTest_mymm >; db2 "select * from sales where sales_person='LEE' and region='Ontario-North'"
- SALES_DATE SALES_PERSON REGION SALES
- ---------- --------------- --------------- -----------
- 03/29/1996 LEE Ontario-North 2
- 03/30/1996 LEE Ontario-North 3
- 03/31/1996 LEE Ontario-North 3
- - LEE Ontario-North -
- 4 record(s) selected.
- CuTest_mymm >; db2 "select coalesce(sales_date,'05/17/2005'),sales_person,region,coalesce(sales,9) from sales where sales_person='LEE' and region='Ontario-North'"
- 1 SALES_PERSON REGION 4
- ---------- --------------- --------------- -----------
- 03/29/1996 LEE Ontario-North 2
- 03/30/1996 LEE Ontario-North 3
- 03/31/1996 LEE Ontario-North 3
- 05/17/2005 LEE Ontario-North 9
- 4 record(s) selected.
复制代码 |
|