ʹÓÃSQLÓï¾äÕÒµ½±íÖÐijÁеĵڼ¸Ãû
SQL> select * from t1;
ID AGE
---------- ----------
1 20
2 19
3 19
4 21
5 22
6 27
6 rows selected.
ÏÖÔÚÒªÇóÕÒ³ö±íÖеÚÈýÄêÇáµÄѧÉú
·½·¨1
µÚÈýÄêÇᣬҲ¾ÍÒâζ×ÅÖ»ÓÐÁ½¸öÈ˱ÈËûС
SQL> select t11.*
2 from t1 t11
3 where 2=(select count(*) from t1 t22 where t11.age>t22.age);
ID AGE
---------- ----------
1 20
·½·¨2
ʹÓô°¿Úº¯Êý
SQL> select id,age
2 from
3 (
4 select id,age,
5 dense_rank() over(order by age) dr
6 from t1
7 )
8 where dr=3;
ID AGE
---------- ----------
4 21
Ææ¹ÖÁË£¬ÕâÀï½á¹ûΪʲô²»Ò»ÑùÄØ£¿»ØÍ·¿´Ò»Ï±íÖеÄÊý¾Ý£¬ÓÐÁ½Ìõage=19µÄÊý¾Ý£¬Õâ¾ÍÊÇÔÒò¡£ÏÂÃæ»»rank
SQL> select id,age
2 from
3 (
4 select id,age,
5 rank() over(order by age) dr
6 from t1
7 )
8 where dr=3;
 
Ïà¹ØÎĵµ£º
Õ⼸ÌìÒ»Ö±±»ÖÐÎÄÂÒÂëÎÊÌâÀ§ÈÅ£¬ÖÐÎÄÊý¾Ý²åÈëµ½My SqlÖкÜÕý³££¬ÔÚCommand client lineÖÐÒ²ÄÜÕý³£ÏÔʾ£¬¿É´ÓÊý¾Ý¿âÖжÁµ½JSPÒ³ÃæÉÏʱ£¬¾Í±ä³É“»ðÐÇÎÄ”ÁË¡£
¡¡¡¡ÓÚÊÇÉÏÍø²éѯ£¬Ò²¿´µ½ºÃ¶à·½·¨£ºÓеÄ˵°Ñmy.iniÖÐdefault-character-set=latin1¸ÄΪdefault-character-set=utf8,ÓÐ ......
SQL Server 2000/2005 ÄêÔÂÈÕ¼ÆËã·½·¨
ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆÚºÍ¼ÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃÇ´ó²¿
·ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâÆªÎÄÕÂÀÎÒ½«¸æËßÄã
ÈçºÎÊ¹Ó ......
ÐÐÁÐתÖõÄSQLÓï¾ä
ÁíÒ»ÖÖÐÐÁÐתÖà -- ¶¯Ì¬ sql ½»²æ±í
===========================================================
×÷Õß: wxy0327(http://wxy0327.itpub.net)
·¢±íÓÚ: 2006.05.10 09:11
·ÖÀà:
Oracle
³ö´¦: http://wxy0327.itpub.net/post/16888/88075
-------------------------- ......
¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì
¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì ÀýÒ»
create proc pr_select_Natural
(
@CDATE datetime,
@FAC_NAME varchar(50),
@BATTERY_TYPE varchar(20),
@MAKE_MODE varchar(20),
@PRODUCE_MODE varchar(20),
@YEAR char(4),
@MONTH char(2 ......