亚洲一区二区三区四区,超碰精品在线,国产视频视频一区

摘要: connect by prior 閱讀全文

posted @ 2008-10-30 18:10 北極雪閱讀(280) | 評(píng)論 (0) | 編輯收藏

摘要: javascript打開(kāi)outlook 閱讀全文

posted @ 2008-10-07 10:33 北極雪閱讀(1052) | 評(píng)論 (3) | 編輯收藏

select /*t5.emp_name as sale_name,
       t9.emp_name as cs_name,
       t5.dept_name,
       t5.friend_id,
       t5.friend_name,
       t5.contract_number,
       t5.total_value,
       t5.so_id,
       t5.start_date,
       t5.end_date,
       t5.friend_phone*/
       count(*)
from (select t1.cust_id as friend_Id,
               t1.so_id,
               t1.emp_id,
               t2.emp_name,
               tf.friend_name,
               t3.dept_name,
               tf.friend_phone,
               t1.so_code as contract_number,
               t1.so_amount as TOTAL_VALUE,
               t1.so_delivery_date as START_DATE,
               t1.so_PAYMENT_DATE as END_DATE
          from tc_sales_order_m t1,
               tc_employee t2,
               tc_department t3,
               tc_friend tf
         where t1.owner_id = 1
           and t2.owner_id = 1
           and t3.owner_id = 1
           and tf.owner_id = 1
           and t1.emp_id = t2.emp_id
           and t2.dept_id = t3.dept_id
           and tf.friend_id=t1.cust_id
        and t1.cust_id in (select td.cust_id
                  from (select
                               tm.cust_id,
                               max(tm.so_payment_date) as end_date
                          from tc_sales_order_m tm
                         where tm.owner_id = 1
                         group by tm.cust_id) td
                 where td.end_date < add_months(sysdate, -3))
           and t3.biz_dept_id = '110'
           and t3.DEPT_CODE not like '0112%'
           and t3.DEPT_CODE not like '0113%') t5,
       (select t4.emp_name, t2.friend_id
          from rel_friend_emp t2, tc_department t3, tc_employee t4
         where t2.emp_id = t4.emp_id
           and t3.dept_id = t4.dept_id
           and t2.owner_id = 1
           and t3.owner_id = 1
           and t4.owner_id = 1
           and t2.is_self = 1
           and t3.biz_dept_id = '130') t9
where t5.friend_id = t9.friend_id(+)

posted @ 2008-09-27 16:14 北極雪閱讀(223) | 評(píng)論 (0) | 編輯收藏

查看是否是新客戶簽的第一單sql

摘要: 查看一個(gè)客戶是否是簽的第一個(gè)單子閱讀全文

posted @ 2008-09-27 14:24 北極雪閱讀(310) | 評(píng)論 (0) | 編輯收藏

三個(gè)查詢的區(qū)別

摘要: 三個(gè)sql的區(qū)別閱讀全文

posted @ 2008-09-25 15:23 北極雪閱讀(262) | 評(píng)論 (0) | 編輯收藏

禁止復(fù)制黏貼

oncopy="return false;" oncut="return false;" oncontextmenu="return false"

posted @ 2008-09-25 09:46 北極雪閱讀(272) | 評(píng)論 (0) | 編輯收藏

sql01

摘要: sql01 閱讀全文

posted @ 2008-09-23 10:08 北極雪閱讀(167) | 評(píng)論 (0) | 編輯收藏

insert into select

摘要: insert 閱讀全文

posted @ 2008-08-29 10:52 北極雪閱讀(624) | 評(píng)論 (0) | 編輯收藏

javascript 比較時(shí)間前后

摘要: javascript 閱讀全文

posted @ 2008-07-30 09:43 北極雪閱讀(1135) | 評(píng)論 (0) | 編輯收藏

c#程序

摘要: c#問(wèn)題閱讀全文

posted @ 2008-04-29 16:18 北極雪閱讀(263) | 評(píng)論 (0) | 編輯收藏

比較前臺(tái)傳來(lái)時(shí)間與當(dāng)前系統(tǒng)時(shí)間,誰(shuí)早誰(shuí)遲問(wèn)題

摘要: 如何比較兩個(gè)日期的先后順序閱讀全文

posted @ 2008-04-24 17:02 北極雪閱讀(778) | 評(píng)論 (4) | 編輯收藏

錯(cuò)誤類型

摘要: 錯(cuò)誤集錦閱讀全文

posted @ 2008-04-12 10:45 北極雪閱讀(193) | 評(píng)論 (0) | 編輯收藏

相信自己！

常用鏈接

留言簿(1)

隨筆分類

隨筆檔案

文章檔案

Blogjava好友

搜索

最新評(píng)論

閱讀排行榜

評(píng)論排行榜

相信自己！