±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1885  |  »Ø¸´: 1

ÐÄâù98_01

½ð³æ (ÕýʽдÊÖ)

[½»Á÷] ¡¾ÇóÖú¡¿¹ØÓÚ²éѯÖдæÔÚÁ¿´ÊµÄÓ÷¨ ÒÑÓÐ1È˲ÎÓë

Êý¾Ý¿âÖйØÓÚ´æÔÚÁ¿´ÊºÍÈ«³ÆÁ¿´ÊÊÇÔõôʹÓõģ¿ÎªÊ²Ã´ÒªÓõ½ÕâЩÁ¿´ÊÄØ£¿Ï£ÍûÖ¸½Ì£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÓàÔó³É

ÖÁ×ðľ³æ (ÖªÃû×÷¼Ò)

´¿´¿¼Ò×åÖ®´¿Ç±·üÕß

¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
SQLÎÞÈ«³ÆÁ¿´Ê£¬µ«¿ÉÒÔ°ÑÈ«³ÆÁ¿´Êת»¯ÎªµÈ¼ÛµÄ´æÔÚÁ¿´ÊÐÎʽ¡£
Àý£º¡°²éѯѡÐÞÈ«²¿¿Î³ÌµÄѧÉúÐÕÃû¡±
(¡Åx)P¡Ô!(Ex(!P))
Ô­ÃüÌâµÈ¼ÛÓÚ£º¡°²éѯÕâÑùµÄѧÉúa£¬²»´æÔÚij¸ö¿Î³Ìx£¬ÕâÃûѧÉúûÓÐÑ¡ÐÞ¡±
SELECT   sname  
FROM  Student
WHERE   NOT EXISTS
        £¨SELECT *
           FROM  Course
           WHERE  NOT EXISTS
                    (SELECT *  
                     FROM  SC   
                      WHERE  sno=Student.sno
                                      AND cno=Course.cno));
ÌìÐн¡£¬¾ý×ÓÒÔ×ÔÇ¿²»Ï¢£¡
2Â¥2011-03-20 16:35:10
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ ÐÄâù98_01 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸Ö£ÖÝ´óѧ²ÄÁÏÓ뻯¹¤×¨Ë¶£¬Ó¢¶þÊý¶þ342·Ö£¬ÇóÀÏʦÊÕÁô +17 v12abo 2026-04-02 18/900 2026-04-03 16:38 by lijunpoly
[¿¼ÑÐ] Çóµ÷¼Á£¬Ò»Ö¾Ô¸ÄϾ©º½¿Õº½Ìì´óѧ £¬080500²ÄÁÏ¿ÆÑ§Ó빤³Ìѧ˶ +7 @taotao 2026-04-03 7/350 2026-04-03 15:07 by hypershenger
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¿Æ¼¼´óѧ²ÄÁϹ¤³Ì085601£¬Çóµ÷¼Á +13 cdyw 2026-04-02 13/650 2026-04-03 14:51 by lsÁõ˧
[¿¼ÑÐ] 368Çóµ÷¼Á +4 ½ñ»ªÏ° 2026-04-03 6/300 2026-04-03 13:46 by ½ñ»ªÏ°
[¿¼ÑÐ] Çóµ÷¼Á +3 ÐÄÏëÊÂ³É¿É 2026-04-03 3/150 2026-04-03 11:22 by wangjy2002
[»ù½ðÉêÇë] ÇëÎʹ²Í¬Í¨Ñ¶ºÍ¹²Í¬Ò»×÷µÄÈϿɶÈÎÊÌâ 10+4 psa1234 2026-04-01 10/500 2026-04-03 11:08 by Kittylucky
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤306·ÖÕÒµ÷¼Á +10 ²×º£ÇáÖÛe 2026-04-03 11/550 2026-04-03 11:07 by à£à£à£0119
[¿¼ÑÐ] 326Çóµ÷¼Á +10 áÌáÌ×Ð 2026-04-02 10/500 2026-04-03 09:08 by ÅÁ¶ûÂíÀ­ÌØ
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÄÏʦ·¶´óѧ-22408¼ÆËã»ú-292·Ö-Çó»ªÄÏʦ·¶´óѧµ÷¼Á +4 °®¶ÁÊéµÄСöùÓã 2026-04-02 4/200 2026-04-02 18:35 by Çóµ÷¼Ázz
[¿¼ÑÐ] ²ÄÁÏ»¯¹¤340Çóµ÷¼Á +5 jhx777 2026-03-30 5/250 2026-04-02 12:45 by smileboy2006
[¿¼ÑÐ] 070300»¯Ñ§Çóµ÷¼Á +14 С»ÆÑ¼±¦ 2026-03-30 14/700 2026-04-02 10:07 by oooqiao
[¿¼ÑÐ] Ò»Ö¾Ô¸9³õÊÔ366 ±¾Ë«·ÇÇóµ÷¼Á +4 ÔËÆøÀ´µÃÈôÓÐËÆÎ 2026-04-02 4/200 2026-04-02 09:56 by guanxin1001
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +12 Ò»ÑùYWY 2026-04-01 12/600 2026-04-02 00:21 by °ÙÃë¹âÄê
[¿¼ÑÐ] 11408 321·ÖÇóµ÷¼Á +3 huchun12138 2026-03-30 4/200 2026-04-01 22:48 by guanxin1001
[¿¼ÑÐ] 266·Ö£¬Ò»Ö¾Ô¸µçÆø¹¤³Ì£¬±¾¿Æ²ÄÁÏ£¬Çó²ÄÁÏרҵµ÷¼Á +10 ÍÛºôºßºôºß 2026-04-01 11/550 2026-04-01 21:48 by chyhaha
[¿¼ÑÐ] 265Çóµ÷¼Á +11 yelck 2026-04-01 12/600 2026-04-01 19:12 by 549790059
[¿¼ÑÐ] 070300»¯Ñ§354Çóµ÷¼Á +15 101´ÎÏ£Íû 2026-03-28 15/750 2026-03-31 17:58 by jp9609
[¿¼ÑÐ] 353Çóµ÷¼Á +3 ½­ÉÏ·ã_26 2026-03-28 3/150 2026-03-31 15:53 by jp9609
[¿¼ÑÐ] Ò»Ö¾Ô¸Öк£Ñó²ÄÁÏ357 +4 Âó¶÷Àò. 2026-03-30 4/200 2026-03-31 14:35 by ¼Çʱ¾2026
[¿¼ÑÐ] 283Çóµ÷¼Á +3 A child 2026-03-28 3/150 2026-03-28 15:41 by ms629
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û