|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
mohuashin
µù¥U®É¶¡: 2003-11-16 ¤å³¹: 7
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤T¤ë 27, 2016 10:37 pm ¤å³¹¥DÃD: ½Ð±Ð¦U¦ì«e½ú ¤l¬d¸ßªº°ÝÃD.. |
|
|
¦U¦ì«e½ú¤j®a¦n,¤p§Ì¦³Ó¤l¬d¸ß°ÝÃD,½Ð¦U«e½ú«ü¾É..
¦³¤TÓªí®æ:
1.¾Ç¥ÍÀÉ(¾Ç¸¹,©m¦W)
2.¿ï½ÒÀÉ(¾Ç¸¹,½Ò¸¹)
3.½Òµ{ÀÉ(½Ò¸¹,½Ò¦W,¾Ç¤À¼Æ,¥²¿ï×)
§Ú·Qn¬d¥X©Ò¦³¾Ç¥Í§¡¿ïתº½Òµ{..
¥H¤U¬O§Úªº¼gªk:
select ½Ò¦W from ½Òµ{ÀÉ where not exists (select * from ¾Ç¥ÍÀÉ;
where not exists ( select * from ¿ï½ÒÀÉ where ½Òµ{ÀÉ.½Ò¸¹ = ¿ï½ÒÀÉ.½Ò¸¹;
.and. ¾Ç¥ÍÀÉ.¾Ç¸¹ = ¿ï½ÒÀÉ.¾Ç¸¹))
½Ð±Ð¦U¦ì«e½ú¥H¤W¼gªk¦bvfp9°õ¦æ®É¥X²{¿ù»~.¯à§_½Ð«e½ú«ü¾É¤@¤U,ÁÂÁÂ! |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 28, 2016 3:41 pm ¤å³¹¥DÃD: |
|
|
¶Ã²qªº.
select ½Ò¦W from ½Ò¥Ý§eÀÉ where not exists (select * from ¾Ç¥ÍÀÉ;
where not exists ( select * from ¿ï½ÒÀÉ,½Ò¥Ý§eÀÉ,¾Ç¥ÍÀÉ where ½Ò¥Ý§eÀÉ.½Ò¸¹ = ¿ï½ÒÀÉ.½Ò¸¹;
.and. ¾Ç¥ÍÀÉ.¾Ç¸¹ = ¿ï½ÒÀÉ.¾Ç¸¹)) _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 28, 2016 5:57 pm ¤å³¹¥DÃD: |
|
|
Ó¤H¤£·| Select SQL ¤l¬d¸ß = ='''
¤U±¦³Ó°½¦Y¨B·§©À,¤£ª¾¾A¤£¾A¥Î?
set dele on
sele 0
*²Îp¾Ç¥ÍÁ`¼Æ
sele count(*) as tn1 from ¾Ç¥ÍÀÉ into curs test1
sele 0
sele ½Ò¸¹,count(*) as tn1 from ¿ï½ÒÀÉ grou by ½Ò¸¹ into curs test2
sele 0
*©Ò¦³¾Ç¥Í³£¦³¿ïªº½Ò¸¹
sele a.* from test2 a,test1 b wher a.tn1=b.tn1 into curs test3 |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 29, 2016 10:11 am ¤å³¹¥DÃD: |
|
|
¤]¬O¶Ã²q
vfp9 ªº sql »yªk, ¦³ not exists ³oÓªF¦è¶Ü? |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 29, 2016 10:18 am ¤å³¹¥DÃD: |
|
|
ckp6250 ¼g¨ì: | ¤]¬O¶Ã²q
vfp9 ªº sql »yªk, ¦³ not exists ³oÓªF¦è¶Ü? |
§Aªº·Qªk¸ò§Ú¤@¼Ë,©Ò¥H§Ú¦³¥h§ä,
VFP 6 HELP:
========
Example 6 displays FilterCondition in the form of [NOT] EXISTS (Subquery)
This example checks to see whether at least one row meets the criterion in the subquery. When the filter condition includes EXISTS, the filter condition evaluates to true (.T.) unless the subquery evaluates to the empty set.
EXISTS ;
(SELECT * FROM orders WHERE customer.postalcode = orders.postalcode)
========
VFP6 ´N¦³¤F.
¦ý§Ú¨S¹êÅç¹L,¦p¼Ó¥D©Ò»¡,Âù«¤l¬d¸ß,
¤~»¡¬O²qªº.
VFP9 ºô¤Í½Ķª©¤¤¤åHELP ¦b ¡u¬d¸ß»P¸ê®Æ¶°ªº¹LÂo±ø¥ó¡v¤@¸`¤¤:
=========
¹LÂo¿ï¶µ©MÈ
±z¥i¥H¨Ï¥Î¤ñ¹ï¹Bºâ¤l¤§¥~ªº¹LÂo¿ï¶µ¡A±q¦Ó¦Ûq±zªº¹LÂo±ø¥ó¬°°O¿ýªº¿ï©w¤l¶°¡C¦b¨Ï¥Î³o¨Ç¿ï¶µ®É¡A¹LÂo±ø¥óªº»yªk¥i¥H¬O¤U¦C¤§¤@¡G
FieldName¡@Comparison¡@Expression | ALL (Subquery) | ANY (Subquery) | SOME (Subquery)
¡Ð©ÎªÌ¡Ð
FieldName [NOT] LIKE cExpression | IS [NOT] NULL | [NOT] BETWEEN Start_Range AND End_Range | [NOT] IN Value_Set | [NOT] IN (Subquery)
¡Ð©ÎªÌ¡Ð
[NOT] EXISTS (Subquery)
¶È·í¤l¬d¸ß¶Ç¦^¦Ü¤Ö¤@µ§°O¿ý®É¡A¬d¸ß¤~¥]§tµ²ªG¡CEXISTS ¤l¥yªºµ²ªG¬°¯u (.T.) ©Î°² (.F.)¡C
ª`·N¡G
°£«D¤l¬d¸ßµ²ªG¬°ªÅ¶°¡A§_«h EXISTS (Subquery) ¤l¥yµ²ªG¬°¯u (.T.)¡C
========
¶¶«K¤]´£¤@¤U,¨ä¹ê§Ú¤£ª¾¹D¼Ó¥D¦b¼g¤°»ò.
¯Âºé´N¨º¥y»yªk¥»¨°ÝÃD°Q½×¤@¤U. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤T¤ë 31, 2016 11:49 am ¤å³¹¥DÃD: |
|
|
¨ü±Ð¤F!
¦ý¡A¬J«K¦³¡@[NOT] EXISTS¡@¥i¥Î¡A¼Ó¥Dªº»yªkÁÙ¬O¤£¹ï
[NOT] EXISTS¡@ªº«e±¡AÀ³¸Ón¦³¤@ÓÄæ¦W |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤T¤ë 31, 2016 4:54 pm ¤å³¹¥DÃD: |
|
|
ckp6250 ¼g¨ì: | ¨ü±Ð¤F!
¦ý¡A¬J«K¦³¡@[NOT] EXISTS¡@¥i¥Î¡A¼Ó¥Dªº»yªkÁÙ¬O¤£¹ï
[NOT] EXISTS¡@ªº«e±¡AÀ³¸Ón¦³¤@ÓÄæ¦W |
¤£»Ýn. «¢,§A¸ò§Ú·Qªº¤@¼Ë. EXISTS «Ü¤Ö¥Î,¦³ÂI»~¸Ñ.
¥un EXIST «á±±µªº¤l¬d¸ß¦³¥ô·N¤@µ§°O¿ý¥H¤W,±ø¥ó´N¬OTRUE.µL°O¿ý´N¬O FALSE,
¤£ºÞ³oµ§°O¿ý¦³¤°»ò·N«ä.
¨Ò¦p:
¦³¤@TABLE¥sÁ~¤ô
SELECT * FROM ½Òµ{ªí where exists select * from Á~¤ô where Á~¤ô>0
¥un select * from Á~¤ô where Á~¤ô>0 ¦³¶W¹L¤@µ§°O¿ý,
´N·|¶Ç¦^ SELECT * FROM ½Òµ{ªí,
¦ý³o¤£ª¾¹D¦b¼g¤°»ò,
½Òµ{ªí»PÁ~¤ô¦³¤°»òÃö«Y.
©Ò¥H§Ú¤~»¡,§Ú¤£ª¾¹D¼Ó¥D¦b¼g¤°»ò.
¦ý¬OSQL »yªk³Õ¤jºë²`,«D¤Z¤Ò«U¤l¥i¥H§¹¥þ°Ñ³z,
¥u¯à°²³]¼Ó¥Dª¾¹D¦Û¤v¦b¼g¤°»ò.
¬G¯Âºé´N»yªk¨Ó»¡,
select * from ¿ï½ÒÀÉ where ½Òµ{ÀÉ.½Ò¸¹ = ¿ï½ÒÀÉ.½Ò¸¹ .and. ¾Ç¥ÍÀÉ.¾Ç¸¹ = ¿ï½ÒÀÉ.¾Ç¸¹
¨S¦³ JOIN ½Òµ{ÀɤξǥÍÀÉ. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¥|¤ë 02, 2016 4:05 pm ¤å³¹¥DÃD: |
|
|
¥N½X: |
§Ú·Qn¬d¥X©Ò¦³¾Ç¥Í§¡¿ïתº½Ò�{..
|
§Ú¨Ó²q¤@²q
SELECT ½Ò¦W FROM ½Òµ{ÀÉ WHERE ½Ò¸¹ in (;
SELECT a.½Ò¸¹ FROM ( ;
SELECT ½Ò¸¹,COUNT(*) AS ¿ïפH¼Æ FROM ¿ï½ÒÀÉ GROUP BY ½Ò¸¹) a ;
where a.¿ïפH¼Æ in (select COUNT(*) from ¾Ç¥ÍÀÉ)) b
¦]¬°n²Å¦X¡i©Ò¦³¾Ç¥Í§¡¿ïתº½Òµ{¡j¡A¦]¦¹¡A§Ú¥ý¥[Á`¦U½Òµ{¤§¿ïפH¼Æ¡A¥[§¹¤§«á¡A¦A¤ñ¹ï¾Ç¥Í¤H¼Æ¡A¥u¦³·í¡i¾Ç¥Í¤H¼Æ¡j¡×¡i¿ïפH¼Æ¡j®É¡A³oÓ½Òµ{¤~¨q¥X¨Ó¡C
¦p¦Psyntech¤j¤j©Ò¨¥¡A¡iSQL »yªk³Õ¤jºë²`¡j¤]µÛ¹ê¦nª±¡I |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¥|¤ë 03, 2016 10:31 pm ¤å³¹¥DÃD: |
|
|
¤£ª¾¹D¯à¤£¯à°õ¦æ:
select * from ½Òµ{ÀÉ where ½Ò¸¹ not in
(
select distinct ½Ò¸¹ from
(select ¾Ç¥ÍÀÉ.¾Ç¸¹,½Òµ{ÀÉ.½Ò¸¹ from ¾Ç¥ÍÀÉ cross join ½Òµ{ÀÉ) b
where b.¾Ç¸¹+b.½Ò¸¹ not in (select ¾Ç¸¹+½Ò¸¹ from ¿ï½ÒÀÉ)
)
¥ýCROSS JOIN ©Ò¦³²Õ¦X,¦A§ä¥X¨S¦b¿ï½Òªíªº½Ò¸¹,
±q½Òµ{ªí«c°£³o¨Ç¨S¦b¿ï½Òªíªº½Ò¸¹,
´N¬O¤j®a³£¦³¿ïªº½Ò¸¹.
CROSS JOIN ½Ð¤Å¨Ï¥Î¦b¤@¶¡¾Ç¥Í¼Æ¶q¶W¹L¼Æ¸U¤H,¥²¿ï×½Òµ{¶W¹L¼Æ¦ÊºØªº¾Ç®Õ.
_________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¥|¤ë 04, 2016 3:52 pm ¤å³¹¥DÃD: |
|
|
¥N½X: |
CROSS JOIN ½Ð¤Å¨Ï¥Î¦b¤@¶¡¾Ç¥Í¼Æ¶q¶W¹L¼Æ¸U¤H,¥²¿ï×½Òµ{¶W¹L¼Æ¦ÊºØªº,
|
¦ý¹q¸£³]³Æ°ª©ó¶W¯Å¹q¸£µ¥¯ÅªÌ°£¥~! |
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|