sqlÓï¾äÎÊÌâ - Java / Web ¿ª·¢
select o_customer,o_price from orders having o_price >=avg(o_price)
select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders)
ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐÇø±ð¡£
o_ id o_date o_price o_customer
1 2008-12-29 1000 bush
2 2008-11-23 1600 carter
3 2008-10-05 700 bush
4 2008-09-28 300 bush
5 2008-08-06 2000 adams
6 2008-07-21 100 carter
having o_price >=avg(o_price)
Õâ¸öÊÇ·Ö×éµÄÌõ¼þ°É ÊÇÓÃÀ´¹ýÂËÏÔʾµÄ×éµÄ
where ÊǹýÂËÐеģ¬Ó¦¸ÃÓÐÇø±ðµÄ£¬µ«ÄãÕâÑùд£¬²»¼Ógroup by ûÊÔÑé¹ý¡£²»ÖªµÀÊÇʲôÒâ˼£¡
where ×Ó¾äµÄ×÷ÓÃÊÇÔÚ¶Ô²éѯ½á¹û½øÐзÖ×éÇ°£¬½«²»·ûºÏwhereÌõ¼þµÄÐÐÈ¥µô£¬¼´ÔÚ·Ö×é֮ǰ¹ýÂËÊý¾Ý£¬Ìõ¼þÖв»ÄÜ°üº¬¾Û×麯Êý£¬Ê¹ÓÃwhereÌõ¼þÏÔʾÌض¨µÄÐС£
having ×Ó¾äµÄ×÷ÓÃÊÇɸѡÂú×ãÌõ¼þµÄ×飬¼´ÔÚ·Ö×éÖ®ºó¹ýÂËÊý¾Ý£¬Ìõ¼þÖо³£°üº¬¾Û×麯Êý£¬Ê¹ÓÃhaving Ìõ¼þÏÔʾÌض¨µÄ×飬Ҳ¿ÉÒÔʹÓöà¸ö·Ö×é±ê×¼½øÐзÖ×é¡£
having ×Ӿ䱻ÏÞÖÆ×ÓÒѾÔÚSELECTÓï¾äÖж¨ÒåµÄÁк;ۺϱí´ïʽÉÏ¡£Í¨³££¬ÄãÐèҪͨ¹ýÔÚHAVING×Ó¾äÖÐÖظ´¾ÛºÏº¯Êý±í´ïʽÀ´ÒýÓþۺÏÖµ£¬¾ÍÈçÄãÔÚ SELECTÓï¾äÖÐ×öµÄÄÇÑù¡£ÀýÈ磺
SELECT A COUNT(B) from TABLE GROUP BY A HAVING COUNT(B)>2
avg(o_price) Óë(select avg(o_price) from orders)ÕâÁ½¸öµÄÇø±ð°É
µÚÒ»¸öÓ¦¸ÃÊÇÿÌõ¼Ç¼µÄƽ¾ùÖµ¡£
µÚ¶þ¸öÓ¦¸ÃÊÇËùÓмǼµÄƽ¾ùÖµ°É
ÎÒSQL²»Õ¦µÎ¡£²»ÖªµÀ¶Ô²»¶Ô¡£
²»ÊǺܶ®£¬µÈ´ý½á¹û¡£
select o_customer,o_price from orders having o_price >=avg(o_price)Ê×ÏÈÓдíÎó¿ÉÒÔд³É(1)select o_customer,o_pri
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
ÎÒдÁ˸öjspÒ³Ã棬Ȼºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³Ãæʱ£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØв¿ÊðÕâ ......