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

sql²éÖØ¸´¼Ç¼

ÓÃselectÓï¾ä£¬²éÑ¯ÖØ¸´¼Ç¼
¼ÙÉ裬±íÃûΪ T1 ×Ó¶ÎΪ A,B,C
select count(*) ,A,B,C from T1
   group by A,B,C having count(*) > 1
²âÊÔÊý¾Ý£º
    A100          B100          C100     
    A101          B101          C101     
    A102          B102          C102     
    A102          B102          C100     
    A102          B102          C102     
    A102          B102          C102     
    A100          B100          C100     
ÔËÐнá¹û£º
2    A100          B100          C100     
3    A102          B102          C102


Ïà¹ØÎĵµ£º

SQL2005ºÍ(Excel |access)Ö®¼äµÄÊý¾Ýµ¼Èëµ¼³ö


Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º    
  
  
--Excel---->SQL2005  µ¼È룺    
  
  
select * into useinfo from O ......

¾­µäSQL£¨2£©

1¡¢¾­µäµÄ²éѯÓï¾ä
2¡¢¾­µäµÄ×Ö¶¨Ò庯Êý
3¡¢¾­µäµÄÓëÒµÎñÏà¹ØµÄ´æ´¢¹ý³Ì
µÈµÈ
1¡¢ ¸ú×Ùµ±Ç°¶Ô»°ÏÂÓû§µÄSQL½Å±¾
select sql_text from v$sqltext_with_newlines where (hash_value,address)
in (select sql_hash_value,sql_address from v$session where sid=&sid)
order by address,piece;
SID
ÓÉÕâ ......

SQl Óï¾ä(³£¼û) н¨,ɾ³ý,Ð޸ıí½á¹¹

н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......

ÇóÌõsqlÓï¾ä,SQLÃæÊÔÌâÄ¿£¬

--ÇóÌõsqlÓï¾ä£º
--   ÒªÇó£º1.°´ÕÕGroup_OutDate×Ö¶ÎÅÅÐò £¬µÃµ½Ç°5Ìõ¼Ç¼
--          2.Group_Name×ֶεÄÖµ²»ÄÜÖØ¸´
SELECT  TOP 5 * from
( SELECT  DISTINCT  Group_Name ,
(SELECT TOP 1 Group_ID from AA_Sell_Group AS b WHERE b.Gro ......

ʵÏÖStandby SQL ServerÊý¾Ý¿âµÄ»ù±¾²½Öè

¡¡¡¡Ê×ÏÈ£¬Ã»ÓÐÈκα¸·ÝÊý¾Ý¿â?
¡¡¡¡ÎÒÃÇʹÓõķþÎñÆ÷Ó²¼þ£¬¿ÉÄÜÊÇÓÉÓÚʹÓÃʱ¼ä¹ý³¤£¬¶øÊ§°Ü;
¡¡¡¡ÊÓ´°ÏµÁзþÎñÆ÷ÉÏ£¬¿ÉÄÜÊÇÀ¶É«»ò¸ÐȾÁ˲¡¶¾£¬SQL ServerÊý¾Ý¿â£¬Ò²¿ÉÄÜÊÇÓÉÓÚÀÄÓûò´íÎó²¢Í£Ö¹ÔËÐС£
¡¡¡¡ÈçºÎÓÐЧµØ±¸·ÝSQL ServerÊý¾Ý¿â£¬ÒÔ±ÜÃâʵ¼Ê·¢ÉúµÄ¹ÊÕÏÍ£»úʱ¼ä³¤£¬Ã¿¸öϵͳ¹ÜÀíÔ±±ØÐëÃæ¶ÔµÄÈÎÎñ¡£
¡¡¡¡2£¬¶Ô± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ