2008-06-11
全文显示

Oracle SQL雜記

SELECT rank() over(ORDER BY phone_no) AS rankNum , CUST_NAME AS custName , COMPANY_NAME AS companyName , PHONE_NO AS phoneNo , EMAIL AS email FROM PHONE_LOG WHERE 1=1   <select id="getOrderNo" resultClass="java.lang.String"> SELECT 'WEB' ||TO_CHAR(SY ...
2008-03-18
全文显示

最高效刪除重復記錄的方法

DELETE FROM MYORDER_ORDER e WHERE e.rowid>(select min(x.rowid) from myorder_order x where e.cust_id = x.cust_id)
cleaneyes
搜索本博客
最近加入圈子
存档
最新评论