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
Ïà¹ØÎĵµ£º
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
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
ÓÉÕâ ......
н¨±í£º
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Óï¾ä£º
-- ÒªÇó£º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 ......
¡¡¡¡Ê×ÏÈ£¬Ã»ÓÐÈκα¸·ÝÊý¾Ý¿â?
¡¡¡¡ÎÒÃÇʹÓõķþÎñÆ÷Ó²¼þ£¬¿ÉÄÜÊÇÓÉÓÚʹÓÃʱ¼ä¹ý³¤£¬¶øÊ§°Ü;
¡¡¡¡ÊÓ´°ÏµÁзþÎñÆ÷ÉÏ£¬¿ÉÄÜÊÇÀ¶É«»ò¸ÐȾÁ˲¡¶¾£¬SQL ServerÊý¾Ý¿â£¬Ò²¿ÉÄÜÊÇÓÉÓÚÀÄÓûò´íÎó²¢Í£Ö¹ÔËÐС£
¡¡¡¡ÈçºÎÓÐЧµØ±¸·ÝSQL ServerÊý¾Ý¿â£¬ÒÔ±ÜÃâʵ¼Ê·¢ÉúµÄ¹ÊÕÏÍ£»úʱ¼ä³¤£¬Ã¿¸öϵͳ¹ÜÀíÔ±±ØÐëÃæ¶ÔµÄÈÎÎñ¡£
¡¡¡¡2£¬¶Ô± ......