ÊÕ¼¯µÄÓÖÒ»µÀÓÐȤµÄSQLÌâ
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê10ÔÂ15ÈÕ 21:59:51±¾Îijö×Ô ¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦http://blog.csdn.net/inthirties/archive/2009/10/15/4673268.aspx °Ñ´ÎÐò²»¶ÔµÄÁÐÕÒ³öÀ´ ÇëÎÊ ÏÂÃæµÄ±í¸ÃÈçºÎÅÅÐò£¿ÎÒÓÐÏÂÃæµÄ±í¡£´ÎÐòÈçÏ ÆäÖеÚ5¸ö¼Ç¼ºÍµÚ6Ìõ¼Ç¼´ÎÐòµßµ¹ÁË¡£Õâ¸ö±íÊý¾ÝÁ¿±È½Ï´ó¡£ ÓÃʲô·½·¨¿ÉÒÔ¶ÔÕâ¸ö±íÖÐµÄ bÁÐÅÅÐò¡£Ê¹ÆäÄܹ»°´ÕÕÉýÐòÅÅÁС£
a b
1 #1¸ËËþ
2 #2¸ËËþ
3 #3.1¸ËËþ
4 #3.2¸ËËþ
5 #5¸ËËþ
6 #4¸ËËþ
7 #6¸ËËþ
8 #7¸ËËþ
9 #9¸ËËþ
10 #8¸ËËþ
ÏÖÔÚÒª×öµÄÊÂÇé¾ÍÊÇ°Ñ ´ÎÐò²»¶ÔµÄÁÐÕÒ³öÀ´¡£ ²»ÊÇÅÅÐò¡£±ÈÈçÉÏÁÐÖÐbÁеÚ5£¬µÚ6ÁС£µÚ9£¬10´ÎÐò²»¶Ô¡£ ÏÖÔÚÒª°ÑÆäÖеÄÁÐÕÒ³öÀ´¡£
5 #5¸ËËþ
6 #4¸ËËþ
9 #9¸ËËþ
10 #8¸ËËþ
¾ÍÊǰÑÕâÑùµÄÁÐÄܹ»ÕÒ³öÀ´¡£ SQL> with temp as(
2 select 1 a, '#1¸ËËþ' b from dual union all
3 select 2 a, '#2¸ËËþ' b from dual union all
4 select 3 a, '#3.1¸ËËþ' b from dual union all
5 select 4 a, '#3.2¸ËËþ' b from dual union all
6 select 5 a, '#5¸ËËþ' b from dual union all
7 select 6 a, '#4¸ËËþ' b from dual
8 ) select a, b from (select temp.*, row_number() over(order by a asc) a_ord,r
ow_number() over(order by to_number(substr(b, 2, length(b)-3)) asc) b_ord from t
emp) t where t.a_ord <>t.b_ord;
A B
---------- --------
6 #4¸ËËþ
5 #5¸ËËþ
Èç¹ûûÓÐÄǾ䡰ÈýÊ®¶øÁ¢¡±£¬ÈýÊ®ËêµÄÄÐÈËÕý¿ÉÒÔÇáÇáËÉËÉ ×¨ÒµÂÛ̳ http://www.inthirties.com ¼¼Êõ²©¿Í http://blog.csdn.net/inthirties ¸öÈËÕ¾µã http://blog.inthirties.com Oracle Mysql¼¼ÊõÂÛ̳| ´òÔìʵÓõÄOracle Mysql¼¼Êõ½»Á÷Ô°µØ
Ïà¹ØÎĵµ£º
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
Êý¾Ý¿â±íµÄ¼Ç¼Èç¹ûÌ«¶à£¬±ÈÈç´ïµ½ÁË20ÍòÒÔÉÏ£¬ÔÚbosÖÐÒ»´ÎÐÔ²é¼Ç¼×ö´¦Àí¿ÉÄÜ»á³öÏÖoutofmemoryµÄ´íÎó£¬ÎÒÃÇÖ»ÄܲÉÈ¡·Ö¶ÎÈ¡¼Ç¼À´´¦Àí£¬¾ßÌåʾÀýÈçÏ£º
/*dialect*/
With Cust AS
( SELECT fnumber,
ROW_NUMBER() OVER (order by fnumber) as RowNumber  ......
/*dialect*/
With Cust AS
( SELECT fnumber,
ROW_NUMBER() OVER (order by id) as RowNumber
from t_bd_currency)
select *
from Cust
Where RowNumber Between 20 and 30
//
  ......
SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ» ......