oracle sql±ÊÊÔÌâ

Ò»¡¢ Êý¾Ý¿â ORACLE
ËäÈ»ÕâЩÌâÄ¿¶¼¿ÉÒÔGµ½£¬µ«»¹ÊÇÒª¿¼²ìÒ»ÏÂÄúÏÖÔڵij£Ì¬Ë®Æ½£¬£º£©
T±í£º£¨×ֶΣºID£¬NAME£¬ADDRESS£¬PHONE£¬LOGDATE£©
E±í£º£¨×ֶΣºNAME£¬ADDRESS£¬PHONE£©
1£® ½«±íTÖеÄ×Ö¶ÎLOGDATEÖÐΪ2001-02-11µÄÊý¾Ý¸üÐÂΪ2003-01-01£¬Çëд³öÏàÓ¦µÄSQLÓï¾ä¡££¨¸Ã×Ö¶ÎÀàÐÍΪÈÕÆÚÀàÐÍ£©
2£® Çëд³ö½«±íTÖÐNAME´æÔÚÖظ´µÄ¼Ç¼¶¼ÁгöÀ´µÄSQLÓï¾ä£¨°´NAMEÅÅÐò£©
3. Çëд³öÌâÄ¿2ÖУ¬Ö»±£ÁôÖظ´¼Ç¼µÄµÚÒ»Ìõ£¬É¾³ýÆäÓà¼Ç¼µÄSQLÓï¾ä£¨¼´Ê¹¸Ã±í²»´æÔÚÖظ´¼Ç¼£©
4. Çëд³ö½«E±íÖеÄADDRESS¡¢PHONE¸üе½T±íÖеÄSQLÓï¾ä£¨°´NAMEÏàͬ½øÐйØÁª£©
5. Çëд³ö½«T±íÖеÚ3~5ÐÐÊý¾ÝÁгöÀ´µÄSQLÓï¾ä
1 update t
   set logdate = to_date('2003-01-01','YYYY-MON-DD')
   from logdate = to_date('2001-02-11','YYYY-MON-DD');
2  select *
    from ( select name from t group by name order by desc)
3 delete from t
    where t.rowid not in ( select  max(rowid)  from t group by name);
Èç¹ûÊǼìË÷ËùÓв»Öظ´µÄÐеĻ°ÄÇôÓÃ
select * from t
where t.rowid not in ( select max(rowid) from t group by ID£¬NAME£¬ADDRESS£¬PHONE£¬LOGDATE)
4  update t
     set t.address = ( select e.address from e,t where t.name = e.name),
           t.phone    = ( select e.phone    from e,t where t.name = e.name);
5.select * from t where rownum <= 5
    minus
   select * from t where rownum < 3;
  or
   select * from ( select rownum as rn,t.* from t ) s
    where s.rn between 3 and 5;