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

sqlÓÅ»¯ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

SQL code:

select a.transactionid, a.creator, a.creattime, a.updatetime,
a.status, a.handletimes, a.operatetype, a.objecttype,
a.objectid, a.objectname, a.objecturl, a.nettype,
a.netid, a.returntime, a.returncode, a.returndesc, a.netstatus,b.netname
from t_cms_transaction a,
( select distinct netid, nettype, contenttype, netname from t_cms_netconf ) b
where a.netid = b.netid
and a.nettype = b.nettype
and a.objecttype = b.contenttype || v_sql
order by 1


  v_sql: °üº¬¶à¸ö²éѯ×ֶεĶ¯Ì¬sql¡£¹Ê²»ºÃÔÚÏà¹Ø×ֶν¨Ë÷Òý£¡

  a±íÊý¾ÝÁ¿£º1000W
  b±íÊý¾ÝÁ¿: 500

  ÒÔÉÏsqlÖ´ÐÐÒ»±éÒª30·ÖÖÓ£¬Çë´ó¼Ò°ïæÓÅ»¯Ï£¡Ð»Ð»£¡ÔÚÏߵȣ¡
  
  

ʹÓÃuse_hash(a b)hintÌáʾЧ¹ûÒ²²»Ã÷ÏÔ£¡

²»ÅÅÐò»á¿ìºÜ¶àµÎ˵¡£¹þ£¬´¿Êô°ï¶¥ = =£¡

bΪʲôҪµ¥¶À×ö³ÉÒ»¸öÐé±í?

ÒýÓÃ
SQL code

select a.transactionid, a.creator, a.creattime, a.updatetime,
a.status, a.handletimes, a.operatetype, a.objecttype,
a.objectid, a.objectname, a.objecturl, a.nettype,
¡­¡­


|| v_sql ÊDz»ÊǸúµÄ¶¼ÊÇһЩÌõ¼þ£¿£¿

Èç¹ûÊÇһЩÌõ¼þµÄ»°¿ÉÒÔÏÈ¿¼ÂÇ 
with tem as (
select a.transactionid, a.creator, a.creattime, a.updatetime, 


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ