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

SQL º¯ÊýµÄÓ÷¨

¼ÈÈ»Êý¾Ý¿âÖÐÓÐÐí¶à×ÊÁ϶¼ÊÇÒÑÊý×ÖµÄÐÍ̬´æÔÚ£¬Ò»¸öºÜÖØÒªµÄÓÃ;¾ÍÊÇÒªÄܹ»¶ÔÕâЩÊý×Ö×öһЩÔËË㣬ÀýÈ罫ËüÃÇ×ÜºÏÆðÀ´£¬»òÊÇÕÒ³öËüÃÇµÄÆ½¾ùÖµ¡£SQL ÓÐÌṩһЩÕâÒ»ÀàµÄº¯Êý¡£ËüÃÇÊÇ£º
AVG (ƽ¾ù)
COUNT (¼ÆÊý)
MAX (×î´óÖµ)
MIN (×îСֵ)
SUM (×ܺÏ)
ÔËÓú¯ÊýµÄÓï·¨ÊÇ£º
SELECT "º¯ÊýÃû"("À¸Î»Ãû")
from "±í¸ñÃû"
¾ÙÀýÀ´Ëµ£¬ÈôÎÒÃÇÒªÓÉÎÒÃǵÄʾ·¶±í¸ñÖÐÇó³ö Sales À¸Î»µÄ×ܺϣ¬
Store_Information ±í¸ñ
store_name
Sales
Date
Los Angeles
$1500
Jan-05-1999
San Diego
$250
Jan-07-1999
Los Angeles
$300
Jan-08-1999
Boston
$700
Jan-08-1999
ÎÒÃǾʹòÈ룬
SELECT SUM(Sales) from Store_Information
½á¹û:
SUM(Sales)
$2750
$2750 ´ú±íËùÓÐ Sales À¸Î»µÄ×ܺÏ: $1500 + $250 + $300 + $700.
³ýÁ˺¯ÊýµÄÔËÓÃÍ⣬SQL Ò²¿ÉÒÔ×ö¼òµ¥µÄÊýѧÔËË㣬ÀýÈç¼Ó(+)ºÍ¼õ(-)¡£¶ÔÓÚÎÄ×ÖÀàµÄ×ÊÁÏ£¬SQL Ò²Óкü¸¸öÎÄ×Ö´¦Àí·½ÃæµÄº¯Êý£¬ÀýÈçÎÄ×ÖÏàÁ¬ (concatenation)£¬ÎÄ×ÖÐÞÕû (trim)£¬ÒÔ¼°×Ó×Ö´® (substring)¡£²»Í¬µÄÊý¾Ý¿â¶ÔÕâЩº¯ÊýÓв»Í¬µÄÓï·¨£¬ËùÒÔ×îºÃÊDzο¼ÄúËùÓÃÊý¾Ý¿âµÄÐÅÏ¢£¬À´È·¶¨ÔÚÄǸöÊý¾Ý¿âÖУ¬ÕâЩº¯ÊýÊÇÈçºÎ±»ÔËÓõġ£


Ïà¹ØÎĵµ£º

SQLÖÐexistsºÍinµÄÇø±ð

¼ÙÉèÈçÏÂÓ¦Óãº
Á½Õű헗Óû§±íTDefUser£¨userid£¬address,phone£©ºÍÏû·Ñ±íTAccConsume(userid,time,amount)£¬ÐèÒª²éÏû·Ñ³¬¹ý5000µÄÓû§¼Ç¼¡£
ÓÃexists:
select * from TDefUser
where exists (select 1 from TAccConsume where TDefUser.userid=TAccConsume.userid and TAccConsume.amount>5000)
ÓÃi ......

Êý¾Ý¿âÆÚÄ©¸´Ï° SQLÓïÑÔ

Ò»¡¢SQLÓïÑÔÖ÷Òª×é³É²¿·Ö   ¶þ¡¢DDL ˵Ã÷£ººóÐøµÄËùÓвÙ×÷Õë¶Ôcreate table Öн¨µÄÈýÕÅ±í ¢Ùcreate table
student±í£º 1  Create Table Student  2  ( 3     ......

Àμǣ¡SQL ServerÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ(SQLÊÕ²Ø)

Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Äã¶¼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâÆªÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾­Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......

[Õª]ÔÚSQLÖÐɾ³ýÖØ¸´¼Ç¼µÄ¶àÖÖ·½·¨

[Õª]ÔÚSQLÖÐɾ³ýÖØ¸´¼Ç¼µÄ¶àÖÖ·½·¨
±¾ÎÄ×ܽáÁËһЩɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¬ÔÚOracleÖУ¬¿ÉÒÔͨ¹ýΨһrowidʵÏÖɾ³ýÖØ¸´¼Ç¼£»»¹¿ÉÒÔ½¨ÁÙʱ±íÀ´ÊµÏÖ...ÕâÀïÖ»Ìáµ½ÆäÖеļ¸ÖÖ¼òµ¥ÊµÓõķ½·¨£¬Ï£Íû¿ÉÒԺʹó¼Ò·ÖÏí£¨ÒÔ±íemployeeΪÀý£©¡£
SQL> desc employee
 Name         ......

SQL SELECTµÄÓ÷¨

ÊÇÓÃÀ´×öʲôµÄÄØ£¿Ò»¸ö×î³£Óõķ½Ê½Êǽ«×ÊÁÏ´ÓÊý¾Ý¿âÖеıí¸ñÄÚÑ¡³ö¡£´ÓÕâÒ»¾ä»Ø´ðÖУ¬ÎÒÃÇÂíÉÏ¿ÉÒÔ¿´µ½Á½¸ö¹Ø¼ü×Ö£º ´Ó (from) Êý¾Ý¿âÖеıí¸ñÄÚÑ¡³ö (SELECT)¡£(±í¸ñÊÇÒ»¸öÊý¾Ý¿âÄڵĽṹ£¬ËüµÄÄ¿µÄÊÇ´¢´æ×ÊÁÏ¡£ÔÚ±í¸ñ´¦ÀíÕâÒ»²¿·ÖÖУ¬ÎÒÃÇ»áÌáµ½ÈçºÎʹÓà SQL À´É趨±í¸ñ¡£) ÎÒÃÇÓÉÕâÀï¿ÉÒÔ¿´µ½×î»ù±¾µÄ SQL ¼Ü¹¹£º
SE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ