ºÃµÄSQLÊÕ¼¯ ²»¶Ï¸üÐÂÖÐ

1.Çó1..10żÊýÖ®ºÍ
select sum(level) from dual
where mod(level,2)=0
connect by level
 
2.½«update¸Ä»»³ÉÓÃrowidÀ´ÊµÏÖ¡£
£¨1£©ÐµÄд·¨£º
merge into SNAPSHOT120_2010_572 t1
using (select a.rowid rid, b.vip_level, b.manager_name
       from xyf_vip_info_new b, snapshot120_2010_572 a
     where b.sub_id = a.sub_id) t2
on (t1.rowid=t2.rid)
when matched then
   update set t1.vip_level=t2.vip_level, t1.vip_manager=t2.manager_name
when not matched then
   insert (t1.vip_level) values (null);
 
£¨2£©ÐÂÆæµÄд·¨
UPDATE (SELECT a.vip_level, a.vip_manager,b.vip_level AS b_vip_level, b.manager_name
          from snapshot120_2010_572 a,xyf_vip_info_new b
 
       WHERE b.sub_id = a.sub_id
        )
   SET vip_level = b_vip_level,vip_manager=manager_name;
3.Çó¸÷¸ö·ÖÖµºÍ×ܵÄÊýÄ¿
select decode(grouping(a.com_name),1,'Ô±¹¤×ÜÊý',a.com_name),count(b.com_id)
from a,b
where a.com_id=b.com_id
group by rollup(a.com_name);
 
4. »Ø¹öÊý¾Ýµ½Ìض¨Ê±¼ä 
select *
from oj_group
as of timestamp to_date(sysdate,'yyyymmdd hh24:mi:ss' )