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

SQL WHEREµÄÓ÷¨

ÎÒÃDz¢²»Ò»¶¨Ã¿Ò»´Î¶¼Òª½«±í¸ñÄÚµÄ×ÊÁ϶¼Íêȫץ³ö¡£ÔÚÐí¶àʱºò£¬ÎÒÃÇ»áÐèҪѡÔñÐÔµØ×¥×ÊÁÏ¡£¾ÍÎÒÃǵÄÀý×ÓÀ´Ëµ£¬ÎÒÃÇ¿ÉÄÜֻҪץ³öÓªÒµ¶î³¬¹ý $1,000 µÄ×ÊÁÏ¡£Òª×öµ½ÕâÒ»µã£¬ÎÒÃǾÍÐèÒªÓõ½ WHERE Õâ¸öÖ¸Áî¡£Õâ¸öÖ¸ÁîµÄÓï·¨ÈçÏ£º
SELECT "À¸Î»Ãû"
from "±í¸ñÃû"
WHERE "Ìõ¼þ"
ÈôÎÒÃÇÒªÓÉÒÔϵıí¸ñ×¥³öÓªÒµ¶î³¬¹ý $1,000 µÄ×ÊÁÏ£¬
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 store_name
from Store_Information
WHERE Sales > 1000
½á¹û:
store_name
Los Angeles


Ïà¹ØÎĵµ£º

SQL ÓïÑÔ

SQL²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE ......

MS SQL SERVER±í·ÖÇøµÄÎÊÌâ

×î½ü·ÖÇøMS SQL SERVERµÄ±í·ÖÇø£¬¸Ð¾õÉõÊǸ´ÔÓ¡£ 1. Ŀǰֻ֪µÀMS SQL SERVERÖ§³Ö·¶Î§·ÖÇøhttp://msdn.microsoft.com/zh-cn/library/ms187802.aspx£¬ ÔÚ¹Ù·½ÍøÕ¾µÄ˵Ã÷ÎĵµÀïÃæ£¬Ò²Ã»ÓÐ˵֧³ÖÆäËûµÄ·ÖÇø¡£ÍøÉÏÓÐÐÖµÜ˵»¹Ö§³Öhash·ÖÇø¡£²»ÖªµÀÊÇÔõôʵÏֵġ£ÒòΪʹÓ÷ÖÇøº¯Êý£¬ÎÒÖ»ÖªµÀÄÜŪ³ö·¶Î§·ÖÇø¡£Í¬OracleµÄ±í·ÖÇøÏà± ......

sql ³£Óú¯ÊýµÄÓ÷¨

³£Óú¯Êý
select replicate('a1',3)--a1µÄÖµÖØ¸´Èý´Î
½á¹ûΪ£ºa1a1a1
 
select len('222')
--¼ÆËã×Ö·ûµÄ¸öÊý½á¹ûΪ
 
select datalength('222')
--¼ÆËã×Ö½ÚÊý£¬½á¹ûΪ
 
select datalength(N'222')
-- unicodeÀàÐÍ£¬Õ¼Óøö×Ö½Ú£¬½á¹ûΪ
 
select substring('abcde',1,3)
-- ¸ñʽ£ºsubstr ......

SQLÓαêÔ­ÀíºÍʹÓ÷½·¨


    ÔÚÊý¾Ý¿â¿ª·¢¹ý³ÌÖУ¬µ±Äã¼ìË÷µÄÊý¾ÝÖ»ÊÇÒ»Ìõ¼Ç¼ʱ£¬ÄãËù±àдµÄÊÂÎñÓï¾ä´úÂëÍùÍùʹÓÃSELECT INSERT Óï¾ä¡£µ«ÊÇÎÒÃdz£³£»áÓöµ½ÕâÑùÇé¿ö£¬¼´´Óijһ½á¹û¼¯ÖÐÖðÒ»µØ¶ÁȡһÌõ¼Ç¼¡£ÄÇôÈçºÎ½â¾öÕâÖÖÎÊÌâÄØ£¿ÓαêΪÎÒÃÇÌṩÁËÒ»ÖÖ¼«ÎªÓÅÐãµÄ½â¾ö·½°¸¡£
1.1 ÓαêºÍÓαêµÄÓŵã
    ÔÚÊý¾Ý¿ ......

SQL SELECTµÄÓ÷¨

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