Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql²éѯÖÐÏÔʾÐòºÅ

sql²éѯÖÐÏÔʾÐòºÅ
2009-06-04 09:27
/* ·½·¨Ò»*/
SELECTÐòºÅ= (SELECT COUNT(¿Í»§±àºÅ) from ¿Í»§ AS LiMing
                   WHERE LiMing.¿Í»§±àºÅ<= Chang.¿Í»§±àºÅ),
   ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§ AS Chang ORDER BY 1;
GO
/* ·½·¨¶þ: ʹÓÃSQL Server 2005 ¶ÀÓеÄRANK() OVER () Óï·¨*/
SELECT RANK() OVER (ORDER BY ¿Í»§±àºÅ DESC) AS ÐòºÅ,
      ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§;
GO
/* ·½·¨Èý*/
SELECTÐòºÅ= COUNT(*), LiMing.¿Í»§±àºÅ, LiMing.¹«Ë¾Ãû³Æ
from ¿Í»§ AS LiMing, ¿Í»§AS Chang
WHERE LiMing.¿Í»§±àºÅ>= Chang.¿Í»§±àºÅ
GROUP BY LiMing.¿Í»§±àºÅ, LiMing.¹«Ë¾Ãû³Æ
ORDER BY ÐòºÅ;
GO
/* ·½·¨ËÄ
½¨Á¢Ò»¸ö¡¸×Ô¶¯±àºÅ¡¹µÄ×ֶΣ¬È»ºó½«Êý¾ÝÐÂÔöÖÁÒ»¸öÇøÓòÐÔÔÝ´æÊý¾Ý±í£¬
È»ºóÓɸÃÇøÓòÐÔÔÝ´æÊý¾Ý±íÖУ¬½«Êý¾Ýѡȡ³öÀ´£¬×îºóɾ³ý¸ÃÇøÓòÐÔÔÝ´æÊý¾Ý±í
*/
SELECTÐòºÅ= IDENTITY(INT,1,1),¹ÜµÀ,³ÌÐòÓïÑÔ,½²Ê¦,×ÊÀú
INTO #LiMing
fromÎÊȯµ÷²éÒ»;
GO
SELECT * from #LiMing;
GO
DROP TABLE #LiMing;
GO
/*
·½·¨Îå
ʹÓà SQL Server 2005 ¶ÀÓеÄROW_NUMBER() OVER () Óï·¨
´îÅä CTE £¨Ò»°ãÊý¾Ý±í±í´ïʽ£¬¾ÍÊÇ WITH ÄǶÎÓï·¨£©Ñ¡È¡ÐòºÅ2 ~ 4 µÄÊý¾Ý
*/
WITHÅÅÐòºóµÄͼÊé AS
(SELECT ROW_NUMBER() OVER (ORDER BY ¿Í»§±àºÅ DESC) AS ÐòºÅ,
   ¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from ¿Í»§)
SELECT * from ÅÅÐòºóµÄͼÊé
WHEREÐòºÅ BETWEEN 2 AND 4;
GO


Ïà¹ØÎĵµ£º

oracleÖÐsql loaderµÄÓ÷¨

sql loader ¹¤¾ßËü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾ÝÓеãÂé·³¡£
ÔÚDOCÏÂÃæÊäÈ룺sqlldr userid=user/password@sid control=result.ctl
Àý×Ó:
SQLLDR USERID=zero/zero@ORACLE CONTROL ......

SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö

Ò»¡¢²Ù×÷·ûÓÅ»¯
1¡¢IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓOracleÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³É¹ ......

SQLʱ¼äÀàÐÍÄ£ºý²éѯ

     Êý¾Ý¿âÀàÐÍΪDateTimeÀàÐÍ£¬½«Æä×öÄ£ºý²éѯʱ£¬ÔÚHibernateÖУ¬¿ÉÒÔÓÃÆ´SQLµÄÎÊÌ⽫Æä½â¾ö£¬¼´ÔÚSQL²éѯ·ÖÎöÆ÷дSQLÒ»Ñù£¬µ«ÊÇÀûÓòÎÊýÅäÖã¬Ôò·½·¨ÈçÏ£º
     1¡¢Æ´ÉÏSQL,È磺
            String beginPara= &q ......

[SQL 2000]·¢Éú´íÎó1069£ºÓÉÓڵǼʧ°Ü¶øÎÞ·¨Æô¶¯·þÎñ

ͬʱÆô¶¯ÆäËûsql ·þÎñ»á³öÏÖ ´íÎó1068:ÒÀ´æ·þÎñ»ò×éÎÞ·¨Æô¶¯£¨ÕâÊÇÓÉÓÚ¼¸¸öÏà¹ØÁªµÄ·þÎñÖÐÓÐÒ»¸ö²»ÄÜÆô¶¯£©¡£
´íÎó1069ÊÇÒ»¸öWindows NT/2000µÄϵͳ´íÎó¡£´íÎó1069±íÃ÷·þÎñ²»Äܱ»Æô¶¯£¨µ±Æô¶¯·þÎñʱ·µ»Ø“µÇ¼ʧ°Ü”´íÎ󣩡£ÀýÈ磬µ±Æô¶¯MSSQLServer·þÎñʱ£¬µÃµ½ÈçÏ´íÎóÌáʾ£º
·¢Éú´íÎó1069£ºÓÉÓڵǼʧ° ......

ORACLEÖÐSQLÈ¡×îºóÒ»Ìõ¼Ç¼µÄ¼¸ÖÖ·½·¨

  ÔÚETL¹ý³ÌÖУ¬¾­³£»áÅöµ½È¡½á¹û¼¯µÄ×îºó»ò×îǰһÌõ¼Ç¼¡£ÈçÈ¡»îÆÚ´æ¿îµÄµ±Ç°ÀûÂÊ£¬¿ª»§½ð¶î£¬Ð­¶¨ÀûÂʵȡ£Èç¹û²»ÓÃLOOKUPµÄ·½Ê½£¬Èçͨ¹ýÓαêÈ¡»òÕßETL¹¤¾ßLOOKUP×é¼þʲôµÄ£¬ÔÚÒ»ÌõSQLÀïʵÏÖ£¬Ä¿Ç°ÊµÏÖÓм¸ÖÖ·½·¨¡£
1.ÒÔʱ¼ä»òÆäËû×ֶηÖ×éºóÔÚ×ÔÁ¬×Ô¼º£¬ÕâÑù²»½ö¿ÉÒÔ´ø³öÐèÒªLOOKUPµÄ×ֶΣ¬»¹¿ÉÒÔ´ø³öÆäËûÐèÒªµÄ×Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ