дORACLE SQL

Ò».°´Ó¢ÎÄ×ÖĸÅÅÐò:
        select * from table order by nlssort(name,'NLS_SORT=schinese_pinyin_M');
 ¶þ. дһ¸öSQLÓï¾ä£¬²éѯѡÐÞÁË5Ãſγ̵ÄѧÉúѧºÅºÍÐÕÃû£¨9·ÖÖÓ£©
´ð£ºSQLÓï¾äÈçÏ£º
select stu.sno, stu.sname
from student stu
where (select count(*) from sc where sno=stu.sno) = 5;
Èý. ÔÚSQLÖÐɾ³ýÖظ´¼Ç¼µÄ·½·¨:£¨Óõ½rowid (oracleαÁÐ)£©
1£©Í¨¹ý½¨Á¢ÁÙʱ±íÀ´ÊµÏÖ
SQL>create table temp_emp as (select distinct * from employee) 
SQL>truncate table employee; (Çå¿Õemployee±íµÄÊý¾Ý£©
SQL>rename temp_emp to employee; (ÔÙ½«±íÖØÃüÃû£©
2£©Í¨¹ýʹÓÃrowidÀ´ÊµÏÖ¡£
SQL>delete from employee where rowid not in (
         select max(t1.rowid) from employee t1 group by
         t1.emp_id,t1.emp_name,t1.salary);--ÕâÀïÓÃmin(rowid)Ò²¿ÉÒÔ¡£
ËÄ. TOP NÎÊÌ⣺£¨Óõ½rownum (oracleαÁÐ)£©
--rownumÖ»ÄÜʹÓÃ<=»ò<µÄ¹Øϵ±È½ÏÔËËã·û
select * from s_emp where rownum <= 2;
--²éѯ¹«Ë¾¹¤×Ê×î¸ßµÄ3¸öÈË
/*select * from emp
where rownum <= 3
order by sal desc;*/ ´íÎóµÄ
select * from (select * from emp order by sal desc)
     where rownum <= 3;
Îå.·ÖÒ³²éѯ£º
   --²éѯµÚ1-5Ìõ¼Ç¼
    select * from (select rownum num, s_emp.* from s_emp)
    where num >=1 and num <= 5;