SQL ²éѯ¡°½ö½ö¡±ÖÁÉÙ¡°È«²¿¡±µÄÎÊÌâ
“È«²¿µÄÎÊÌâ”ÔÚÉÏһƪÖÐÒѾд¹ýÒ»µãÁË¡£
“½ö½ö”
£ºÕâ¸öÎÊÌâ¿ÉÒÔʹÓöà±íÁ¬½ÓÀ´´¦Àí¡£ÀýÈ磺²éѯ½ö½öÑ¡ÐÞÁ˿γÌAºÍ¿Î³ÌBµÄѧÉúµÄÐÅÏ¢,sqlÈçÏ£º
ÆäÖбístudent¶¨ÒåÁËѧÉúµÄÐÅÏ¢¡£transcript¶¨ÒåÁËѧÉúµÄÑ¡¿ÎÇé¿ö¡£crscode×ֶαíʾ¿Î³Ì´úÂë¡£
select s.id
from student s,transcript t1,transcript t2
where s.id = t1.studid and t1.studid = t2.studid
and t1.crscode = 'cs305' and t2.crscode = 'mgt123'
ÕâÀïÊÇÈý¸ö±íµÄÁ¬½Ó¡£
“ÖÁÉÙ”£ºÖÁÉÙµÄÎÊÌ⣬Èç¹û
ÖÁÉÙµÄÄÚÈÝÊÇÔ¤ÏÈÖªµÀµÄ£¬È磺²éѯÖÁÉÙÑ¡ÐÞÁ˿γÌAºÍBµÄѧÉú£¬ÕâÑùÒ²ÊÇ¿ÉÒÔʹÓöà±íÁ¬½ÓµÄ¡£
sqlÈçÏ£º
select t1.studid
from transcript t1,transcript t2,student s
where t1.crscode = 'cs305' and t2.crscode = 'cs315' and s.id = t1.studid and t1.studid = t2.studid
µ«ÊÇÈç¹û
ÖÁÉÙµÄÄÚÈÝÊÂÏÈÊDz»ÖªµÀµÄ£¬¾Í²»ÄÜÓöà±íÁ¬½ÓÁË¡£È磺²éѯÖÁÉÙÑ¡ÐÞÁËѧÉúSÑ¡Ð޵Ŀγ̵ÄѧÉú¡£¾ÍÊÇ˵ѧÉúSÑ¡ÐÞÁËһЩ¿Î³Ì£¬
²é²é¿´ÄÄЩѧÉúµÄÑ¡¿ÎÖаüº¬
ÕâЩ¿Î³ÌµÄ¡£ºÜÏÔÈ»sqlÖÐûÓД°üº¬“ÕâÑùµÄν´Ê¡£µ«ÊÇ¿ÉÒÔ½«Õâ¸öÐèÇóת»»ÎªÆäËûµÄÃèÊö·½Ê½£º
²»´æÔÚÕâÑùµÄ¿Î³Ì£¬Ñ§ÉúSÑ¡ÁË£¬µ«ÊǸÃѧÉú
ûÓÐÑ¡¡£
ÕâÀïºì×ֵĔ¸ÃѧÉú“¾ÍÊÇÎÒÃÇÒª²éѯ³öÀ´µÄÄÚÈÝ¡£
sqlÈçÏ£º
Ïà¹ØÎĵµ£º
SELECT TOP 10 *
from HumanResources.Employee
WHERE EmployeeID NOT IN (SELECT TOP 0 EmployeeID from HumanResources.Employee ORDER BY EmployeeID desc)
ORDER BY EmployeeID desc
—————————————————&md ......
1.ʹÓÃPHPµÄMSSQL,ÐèÒª¼ÓÔØPHPµÄMSSQLÀ©Õ¹¡£¾ßÌå·½·¨ÊÇ´ò¿ªphp.iniÎļþ£¬ÕÒµ½ÏÂÃæÒ»ÐдúÂ룺
;extension=php_mssql.dll
È¥µôÐÐÊ׵ķֺţ¬È»ºó±£´æÎªphp.iniÎļþ£¬¼´Íê³ÉPHPµÄMSSQLÀ©Õ¹µÄ¼ÓÔØ¡£
2.PHPÁ¬½ÓSQL ServerµÄ±ØÒªÌõ¼þ
a. SQL Server·þÎñÆ÷µÄÖ÷»úÃû³Æ¡£
b. ÔÊÐí¶Ô·þÎñÆ÷ ......
×Ô£ºhttp://blog.csdn.net/AJAXBloger/archive/2007/08/29/1764506.aspx
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²é
ѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷
SELECT Óï¾äµÄ×î ......
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²éѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷ SELECT Óï¾äµÄ×îºó¡£
ORDER BY ×Ó¾ä¿ÉÒÔʹÓ㬲¢ÇÒÔÚ½øÐÐ Top-N ·ÖÎöʱÊDZØÐëµÄ¡£
3.ÔÚ×Ó² ......
¾ßÓй̶¨ÓÐЧλÊýºÍСÊýλÊýµÄÊýÖµ×ÊÁÏÀàÐÍ¡£
decimal[ (p[ , s] )] and numeric[ (p[ , s] )]
¹Ì¶¨ÓÐЧλÊýºÍСÊýλÊýµÄÊý×Ö¡£µ±Ê¹ÓÃ×î´óÓÐЧλÊýʱ£¬ÓÐЧֵÊÇ´Ó - 10^38 +1 µ½ 10^38 - 1¡£decimal µÄ SQL-92 ͬÒå×ÖÊÇ dec ºÍ dec(p, s)¡£numeric µÄ¹¦ÄÜÏàµ±ì¶ decimal¡£
p (ÓÐЧλÊý)
¿É´¢´æµÄ×î´óÊ®½øÎ»Êý×ÜÊý£¬Ð¡ ......