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

¼¸µÀ¾­µäµÄSQL±ÊÊÔÌâÄ¿

¼¸µÀ¾­µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË      ÉÌÆ·Ãû³Æ     ÊýÁ¿
A            ¼×          2
B            ÒÒ          4
C            ±û          1
A            ¶¡          2
B            ±û          5
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³öËùÓйºÈëÉÌÆ·ÎªÁ½ÖÖ»òÁ½ÖÖÒÔÉϵĹºÎïÈ˼Ǽ
´ð£ºselect * from ¹ºÎïÐÅÏ¢ where ¹ºÎïÈË in (select ¹ºÎïÈË from ¹ºÎïÐÅÏ¢ group by ¹ºÎïÈË having count(*) >= 2);
£¨2£©±íÃû£º³É¼¨±í
ÐÕÃû   ¿Î³Ì       ·ÖÊý
ÕÅÈý     ÓïÎÄ       81
ÕÅÈý     Êýѧ       75
ÀîËÄ     ÓïÎÄ       56
ÀîËÄ     Êýѧ       90
ÍõÎå     ÓïÎÄ       81
ÍõÎå     Êýѧ       100
ÍõÎå     Ó¢Óï       49
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³ö³É¼¨È«²¿ºÏ¸ñµÄѧÉúÐÅÏ¢£¨°üº¬ÐÕÃû¡¢¿Î³Ì¡¢·ÖÊý£©£¬×¢£º·ÖÊýÔÚ60ÒÔÉÏÆÀΪºÏ¸ñ
´ð£ºselect * from ³É¼¨±í where ÐÕÃû not in (select distinct ÐÕÃû from ³É¼¨±í where ·ÖÊý < 60)
»òÕߣº
select * from ³É¼¨±í where ÐÕÃû in (select ÐÕÃû from ³É¼¨±í group by ÐÕÃû having min(·ÖÊý) >=60)
£¨3£©±íÃû£ºÉÌÆ·±í
Ãû³Æ   ²úµØ             ½ø¼Û
Æ»¹û   ÑĮ̀                2.5
Æ»¹û   ÔÆÄÏ                1.9
Æ»¹û   ËÄ´¨     


Ïà¹ØÎĵµ£º

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨

Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£  
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......

ʹÓÃc#´´½¨sql serverµÄ´æ´¢¹ý³Ì_c#Ó¦ÓÃ1

½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêȫ֧³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐͰ²È«¡ ......

PL/SQL developer½«excelÊý¾Ýµ¼ÈëOracle

×¼±¸¹¤×÷£ºÊý¾ÝÇåÏ´¡£¼ì²éÊý¾ÝÀàÐͺͱíÖеÄ×Ö¶ÎÀàÐÍÊÇ·ñÆ¥Å䣻¼ì²é¿ÕÖµÔ¼Êø£»È¥Î޹ؿոñµÈ¡£ÕâЩ¼ì²é¹¤×÷¿ÉÒÔͨ¹ýExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬¿´Ò»ÏÂÿ¸ö×Ö¶ÎËùÓеÄÖµ£¬ÔÙÑ¡Öв»ºÏ¹æ·¶µÄ½øÐÐÐ޸ġ£   
    ²½Ö裺
1£©µÇ¼pl/sql developer£¬µÇ¼ʱѡÔñ´ýµ¼Èë±íËùÔÚÊý¾Ý¿â£¬ÔÚ²éѯ´°¿ÚÀïÊäÈësele ......

SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â

SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......

sql convertÈÕÆÚʱ¼ä¸ñʽ

--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÄêÔÂÈÕ
 select convert(varchar(10),getDate(),120)
--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÊ±·ÖÃë
select convert(varchar(8),getDate(),8)
Convertº¯ÊýµÄһЩ˵Ã÷£¬ÒÔÏÂ×ÊÁÏÀ´Ô´ÓÚÍøÂç
²»´øÊÀ¼ÍÊýλ (yy)
´øÊÀ¼ÍÊýλ (yyyy)

±ê×¼

ÊäÈë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ