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

SQLÌõ¼þ²éѯÓï¾ä

ÈçÌ⣬ÏëʵÏÖÈçÏÂÃèÊöµÄЧ¹û£¬
jcxhÓëch²»Í¬Ê±ÏàµÈ¡£
Èç µÚÒ»ÌõÊý¾ÝΪjcxh=1 ch=2
  µÚ¶þÌõÊý¾ÝΪjcxh=1 ch=3ΪÂú×ãÌõ¼þ
Èç¹ûµÚ¶þÌõÊý¾ÝΪjcxh=1 ch=2¾Í²»Âú×ãÌõ¼þ
дµÄSQL Ìõ¼þÓï¾äÈçÏ£º
where jcxh not  in (select jcxh from ±íA )
and ch not in (select ch from ±íA)
µ«ÊǸоõºÃÏñ²»¶Ô£¬Çë¸÷λ´óÏÀ°ï濴һϡ£
´ó¼Ò°ï濴һϣ¬Ó¦¸ÃÔõôд£¿

SELECT * from TB T WHERE EXISTS(SELECT 1 from TB T WHERE jcxh=T.jcxh AND ch <>T.ch)

ûÓп´¶®£¡

ÄÃÊý¾ÝÀ´£¡

ÎÒÕâÑùд½á¹ûÊDZíBÖÐ
ËùÓÐÔÚ±íAÖгöÏÖµÄjcxh¶¼±»ÌÞ³ý
ËùÓÐÔÚ±íAÖгöÏÖµÄchÒ²¶¼±»ÌÞ³ý¡£

ÎÒÏëÒªµÄ½á¹ûÊDZíAÖÐjxchÓëchͬʱÓë±íBÖÐjxch¡¢chÏàͬʱ²Å±»ÌÞ³ý


µÚ¶þÌõÊý¾ÝΪjcxh=2 ch=2ÊÇ·ñÒ²Âú×ãÌõ¼þ ?

insert into ±íB (jx,ch)
select jcxh,ch
from ±íA 
where jcxh not  in (select jx from ±íB )
and ch not in (select ch from ±íB) 

ÍêÕûµÄ¾ÍÊÇÕâÑù£¬ÎÒÏë¶Ô±íB²åÈëjx£¬ch¡£¶øjxºÍchÊÇ´Ó±íAÖжÁ³öµÄ£¬ÒòΪ²»ÄÜÖØ¸´Ìí¼ÓÊý¾Ý£¬ËùÒÔÏ£ÍûÄÜÌÞ³ýÌí¼Ó¹ýµÄÊý¾Ý¡£


ÒýÓÃ
ÎÒÕâÑùд½á¹ûÊDZíBÖÐ
ËùÓÐÔÚ±íAÖгöÏÖµÄjcxh¶¼±»ÌÞ³ý
ËùÓÐÔÚ±íAÖгöÏÖµÄchÒ²¶¼±»ÌÞ³ý¡£

ÎÒÏëÒªµÄ½á¹ûÊDZíAÖÐjxchÓëchͬʱÓë±íBÖÐjxch¡¢chÏàͬʱ²Å±»ÌÞ³ý


SQL code:
SELECT * from TB T W


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ÇóÒ»SQLÓï¾ä

Ô­Êý¾Ý

ÉÌÆ·    Ô­¼Û    ´òÕÛ·½Ê½1  ÕÛ¿Û1    ´òÕÛ·½Ê½2  ÕÛ¿Û2
±Ê¼Ç±¾  10000  NULL        0      NULL&nb ......

OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ