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

SQL»ù´¡½Ì³Ì

SQL ½Ì³Ì
1£©SQL ¼ò½é
SQL(Structured Query Language£¬½á¹¹²éѯÓïÑÔ)ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âÓïÑÔ¡£SQLͨ³£Ê¹ÓÃÓÚÊý¾Ý¿âµÄͨѶ¡£ANSI£¨ÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£©Éù³Æ£¬SQLÊǹØÏµÊý¾Ý¿â¹ÜÀíϵͳµÄ±ê×¼ÓïÑÔ¡£SQLÓï¾äͨ³£ÓÃÓÚÍê³ÉһЩÊý¾Ý¿âµÄ²Ù×÷ÈÎÎñ£¬±ÈÈçÔÚÊý¾Ý¿âÖиüÐÂÊý¾Ý£¬»òÕß´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£Ê¹ÓÃSQLµÄ³£¼û¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÓУºOracle¡¢ Sybase¡¢ Microsoft SQL Server¡¢ Access¡¢ IngresµÈµÈ¡£ËäÈ»¾ø´ó¶àÊýµÄÊý¾Ý¿âϵͳʹÓÃSQL£¬µ«ÊÇËüÃÇͬÑùÓÐËüÃÇ×ÔÁ¢ÁíÍâµÄרÓÐÀ©Õ¹¹¦ÄÜÓÃÓÚËüÃǵÄϵͳ¡£µ«ÊÇ£¬±ê×¼µÄSQLÃüÁ±ÈÈç"Select"¡¢ "Insert"¡¢ "Update"¡¢ "Delete"¡¢ "Create"ºÍ "Drop"³£³£±»ÓÃÓÚÍê³É¾ø´ó¶àÊýÊý¾Ý¿âµÄ²Ù×÷¡£
¡¡¡¡µ«ÊÇ£¬²»ÏñÆäËüµÄÓïÑÔ£¬ÈçC¡¢PascalµÈ£¬SQLûÓÐÑ­»·½á¹¹£¨±ÈÈçif-then-else¡¢do-while£©ÒÔ¼°º¯Êý¶¨ÒåµÈµÈµÄ¹¦ÄÜ¡£¶øÇÒSQLÖ»ÓÐÒ»¸öÊý¾ÝÀàÐ͵Ĺ̶¨ÉèÖ㬻»¾ä»°Ëµ£¬Äã²»ÄÜÔÚʹÓÃÆäËü±à³ÌÓïÑÔµÄʱºò´´½¨Äã×Ô¼ºµÄÊý¾ÝÀàÐÍ¡£
SQL¹¦ÄÜÇ¿´ó£¬µ«ÊǸÅÀ¨ÆðÀ´£¬Ëü¿ÉÒÔ·Ö³ÉÒÔϼ¸×飺
DML£¨Data Manipulation Language£¬Êý¾Ý²Ù×÷ÓïÑÔ£©£ºÓÃÓÚ¼ìË÷»òÕßÐÞ¸ÄÊý¾Ý£»
DDL£¨Data Definition Language£¬Êý¾Ý¶¨ÒåÓïÑÔ£©£º ÓÃÓÚ¶¨ÒåÊý¾ÝµÄ½á¹¹£¬±ÈÈç ´´½¨¡¢Ð޸ĻòÕßɾ³ýÊý¾Ý¿â¶ÔÏó£»
DCL£¨Data Control Language£¬Êý¾Ý¿ØÖÆÓïÑÔ£©£ºÓÃÓÚ¶¨ÒåÊý¾Ý¿âÓû§µÄȨÏÞ¡£
2£©SQL ³£ÓÃÓï¾ä
2£®1   SELECT Óï¾ä
×÷ÓãºSELECT Óï¾äÓÃÓÚ´Ó±íÖÐѡȡÊý¾Ý¡£½á¹û±»´æ´¢ÔÚÒ»¸ö½á¹û±íÖУ¨³ÆÎª½á¹û¼¯£©¡£
Óï·¨£º
SELECT Ä¿±ê±íµÄÒ»¸ö»ò¶à¸öÁÐÃû³Æ,ÁÐÃûǰ¿É¼Ó±í´ïʽ,Èç:avg(ÄêÁä) from Ä¿±ê±íµÄÃû³Æ;
ÒÔ¼°£º
SELECT * from ±íÃû³Æ;
×¢ÊÍ£º*´ú±íѡȡȫ²¿¡£
 
ʾÀý£º
ÏÂÃæÊÇʾ·¶ÔÚÒ»¸ö±íÖÐѡȡ×Ô¼ºÏëÒªµÄÐÅÏ¢£¬ÀýÈçÎÒÖ»ÏëÒªÀÏʦÃǵÄÁªÏµµç»°¡£
ÕâÊÇÔ­±í£¨½Ìʦ±í£©£¬ÀïÃæ°üº¬Á˽Ìʦ±àºÅµÈµÈÐÅÏ¢£¬ÔÚÕâ¸ö±íÖй¤×÷ʱ¼ä¡¢ÕþÖÎÃæÄ¿µÈµÈ¶¼ÊÇÎÒÃDz»ÐèÒªÖªµÀµÄÐÅÏ¢ËùÒÔÎÒÃÇÒªÓÐÑ¡ÔñµÄѡȡ¡£
Õâ¸öÊÇÔÚSQLÊÓͼÖÐÊäÈëµÄ´úÂ루ÈçºÎ´ò¿ªSQLÊÓͼ²»ÔÚÕâÀïÁо٣©¡£
´úÂëµÄº¬ÒåÊÇ£ºÑ¡È¡“½Ìʦ±àºÅ,ÐÕÃû,ÐÔ±ð,ÁªÏµµç»°“ÕâËĸöÁУ¬ÁеÄÀ´Ô´ÊÇ“½Ìʦ“Õâ¸ö±í
Õâ¸öÊÇ×îÖյĽá¹û£¬¿ÉÒÔ¿´µ½Ö»ÓÐÎÒÃÇÒªµÄ“½Ìʦ±àºÅ,ÐÕÃû,ÐÔ±ð,ÁªÏµµç»°“ÁУ¬ÕþÖÎÃæÄ¿µÈ²¢Ã»ÓÐÔÚÀïÃæ¡£
 
 
ÍØÕ¹1£º
SELECT DISTINCT Óï¾ä
×÷ÓãºÔÚÒ»¸ö±íÖУ¬¿ÉÄÜ»á°üº¬Öظ´Öµ¡£Õâ²¢²»³ÉÎÊÌ⣬²»¹ý£¬ÓÐʱÄãÒ²ÐíÏ£Íû½ö½öÁгö²»Í¬£¨distinct£©µ


Ïà¹ØÎĵµ£º

SQLǶÌ××Ó²éѯ

×Ô£ºhttp://blog.csdn.net/AJAXBloger/archive/2007/08/29/1764506.aspx
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔ­Ôò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²é
ѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷
SELECT Óï¾äµÄ×î ......

SQL ÓÃexists´úÌæÈ«³ÆÁ¿´Ê

ѧϰsqlµÄ±Ø¾­ÎÊÌâ¡£
ѧÉú±ístudent (idѧºÅ     SnameÐÕÃû       SdeptËùÔÚϵ)  
¿Î³Ì±íCourse           (crscode¿Î³ÌºÅ       name¿Î³ÌÃû)  
ѧÉúÑ¡¿Î±ítranscript           (studidѧºÅ &nbs ......

SqlÊý¾ÝÓÅ»¯·½°¸

1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£
Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by·¢ÉúµÄÁУ¬¿É¿¼
Âǽ ......

ÈýÖÐSQL ·ÖÒ³·½·¨Ð§ÂÊ·ÖÎö

ÈýÖÖSQL·ÖÒ³·¨Ð§ÂÊ·ÖÎö
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
¡¡Óï¾äÐÎʽ£ºÀûÓÃNot InºÍSELECT TOP·ÖÒ³) ЧÂÊÖУ¬ÐèҪƴ½ÓSQLÓï¾ä
  SELECT TOP 10 * from  TestTable WHERE (Id  NOT  IN (SELECT  TOP  20    id&n ......

SQL ServerÖÐË÷Òý

Ò»¡¢SQL ServerÖÐÊý¾ÝÐеĴ洢·½Ê½
     ÔÚSQL ServerÖдæ·ÅÊý¾ÝµÄÎļþ»áÒÔ8KBµÄ´óС·ÖÒ³¡£Ã¿Ò»Ò³¿ÉÒÔÊÇÊý¾Ý¡¢Ë÷ÒýÒÔ¼°ÆäËûSQL ServerÊý¾Ý¿âÐèҪΪÆäά»¤Êý¾ÝÎļþµÄÊý¾ÝÀàÐÍ¡£´ó¶àÊýÒ³ÊÇÊý¾ÝÒ³»òË÷ÒýÒ³¡£Ò³ÊÇSQL Server¶Á¡¢Ð´Êý¾ÝÎļþµÄµ¥Ôª¡£Ã¿Ò»Ò³Ö»°üÀ¨Ò»¸ö¶ÔÏóµÄÊý¾Ý»òË÷ÒýÐÅÏ¢£¬ËùÒÔÔÚÿһ¸öÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ