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

sql serverÓï¾ä - MS-SQL Server / »ù´¡Àà

/*²éÕÒͼÊéÀà±ð£¬ÒªÇóÀà±ðÖÐ×î¸ßͼÊ鶨¼Û²»µÍÓÚÈ«²¿°´Àà±ð·Ö×éµÄƽ¾ù¶¨¼ÛµÄ2±¶¡£*/

select * from ͼÊé
where Àà±ð in(
select Àà±ð from ͼÊé
group by Àà±ð 
having max(¶¨¼Û)>=any (select 2*avg(¶¨¼Û) from ͼÊé
group by Àà±ð))

SELECT * from ͼÊé 
GROUP BY Àà±ð HAVING MAX£¨¶¨¼Û£©£¾=ALL
£¨SELECT 2*AVG£¨¶¨¼Û£© from ͼÊé
  GROUP BY Àà±ð£©

ÒÔÉÏÊÇÎÊÌâºÍ´ð°¸ 
Á½×éÓï¾äÊǵȼ۵썴ð°¸ÈçÊÇ˵£©
ÇëÎÊ ÕâÁ½×éÓï¾äÔÚsqlÀïÃæ¾ßÌåµÄÖ´Ðйý³ÌÊÇÔõÑùµÄ
¾ÍÊÇÏñ·Ö×éºÍÇó¾ùֵ˭ÏÈ×öµÄÎÊÌâ
ÏÈ·Ö×éÔÙÇ󯽾ùÖµ

http://blog.csdn.net/feixianxxx/archive/2009/10/18/4694354.aspx

¿É²»¿ÉÒÔ˵һϾßÌåµÄÖ´Ðйý³Ì°¡
ÎÒ¶ÔÕâÁ½×éÓï¾ä²»Àí½â

ÒýÓÃ
http://blog.csdn.net/feixianxxx/archive/2009/10/18/4694354.aspx

Ôõô˵ÊÇÎÞЧµÄµØÖ·°¡


µÚ¶þ¾ä²»¶Ô£¬¡° SELECT * from ͼÊé GROUP BY Àà±ð HAVING MAX£¨¶¨¼Û£©£¾=ALL £¨SELECT 2*AVG£¨¶¨¼Û£© from ͼÊé GROUP BY Àà±ð£©¡±£¬¼ÈÈ»·Ö×éÁË£¬Ç°ÃæÐ´ select * ¿Ï¶¨»á³ö´íµÄ¡£


½èµØ·½ÎÊһϣ¬¡° ALL¡±ÔÚÕâ¾äÀïÊÇʲôÒâ˼°¡£¿

ÒýÓÃ
http://blog.csdn.net/feixianxxx/archive/2009/10/18/4694354.aspx
͉ȯ

Õâ»ØºÃÁË ºÇºÇ

ÒýÓÃ
µÚ¶þ¾ä²»¶Ô£¬¡° SELECT * from ͼÊé GROUP BY Àà±ð HAVING MAX£¨¶¨¼Û£©£¾=ALL £¨SELECT 2*AVG£¨¶¨¼Û£© from ͼÊé GROUP BY Àà±ð£©¡±£¬¼ÈÈ»·Ö×éÁË£¬Ç°Ã


Ïà¹ØÎÊ´ð£º

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

sql ²éѯ - MS-SQL Server / »ù´¡Àà

ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ  
ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ
Óï¾äÈçÏ£º
SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ