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

SQLÓÃselectÓï¾ä²éÑ¯ÖØ¸´¼Ç¼

SQLÓÃselectÓï¾ä²éÑ¯ÖØ¸´¼Ç¼
http://hi.baidu.com/bilbit/blog/item/5ed5de16a6f6b412962b43eb.html
ÓÃ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     
========================================================
Ñ¡ÔñÖØ¸´£¬Ïû³ýÖØ¸´ºÍÑ¡Ôñ³öÐòÁÐ
ÓÐÀý±í£ºemp
emp_no   name    age   &nbs


Ïà¹ØÎĵµ£º

SQL Server2000 ½âÎöXML

DECLARE @HDOC INT --Îĵµ¾ä±ú
DECLARE @XMLSTRING VARCHAR(200) --XML×Ö·û´®
SET @xmlString ='<?xml version="1.0"?>
<ROOT>
<USER ID="1" Name="SBQCEL"/>
<USER ID="2" Name="PEACELI"/>
<USER ID="3" Name="SHEEPCHANG"/>
</ROOT>'
--ʹÓÃϵͳ´æ´¢ ......

SQL ²é詢²»區·Ö´óС寫

SQL ²é詢²»區·Ö´óС寫
2007Äê04ÔÂ19ÈÕ ÐÇÆÚËÄ 15:27
Õý³£ÓÃÕâ¸ö·½·¨¾Í¸ø達µ½Ð§¹ûÁË¡£select * from
pl_account     where UPPER(fname) like 'PE%'
¸½¼Ó£º
ÔÚsql2000ºÍ7.0µÄ²éѯÓï¾äÖÐ,Çø·Ö´óдµÄ²éѯ·½·¨
--sql2000,¾ÍÓÃÏÂÃæµÄ·½·¨.
--¾ÍÊÇÔÚ×Ö¶ÎÃûºó¼Ó collate Chi ......

ÌáÉýOracleÐÔÄÜÖ®SQLµÄÓÅ»¯Ïêϸ·ÖÎö

SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ»¯Ô ......

×Ô¶¨Òå¶à²ÎÊýSql¾ÛºÏº¯Êý

Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function
In part 1 we created a nice user defined aggregate. Now we are going to make it more sophisticated and let its value depend on two parameters ShipCountry and ShipShipCity. You might try having two parame ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ