ͼ3-6
¹Ø±Õ²¢±£´æ£¬ÐÞ¸ÄѧºÅ2001110µÄѧÉú³É¼¨Îª£·£°Íê³É¡£ 5) ɾ³ýѧºÅ2001110µÄѧÉú³É¼¨µÄ¼Ç¼
ÈçÉÏͼ3-6Ëùʾ£¬Ñ¡ÔñѧºÅΪ¡±2001110¡±µÄѧÉú£¬µã»÷ÓÒ¼üÑ¡Ôñ¡°É¾³ý¡±Ñ¡Ï¿Éɾ³ýѧºÅΪ¡±2001110¡±µÄѧÉú£¬É¾³ýºóÈçÏÂͼ3-7Ëùʾ¡£
µÚ 25 Ò³ ¹² 50 Ò³
ͼ3-6
¹Ø±Õ²¢±£´æ¡£É¾³ýѧºÅΪ¡°2001110¡±µÄѧÉú¼Ç¼Íê³É¡£ 6) ΪѧÉú±í´´½¨Ò»¸öÃûΪ IX-ClassµÄË÷Òý£¬Ò԰༶ºÅÅÅÐò ´ò¿ª3-2´°¿Ú£¬µã»÷ÓÒ¼üÑ¡Ôñ¡°Ë÷Òý£¯¼ü¡±ÈçÏÂͼ3-7Ëùʾ¡£
µÚ 26 Ò³ ¹² 50 Ò³
ͼ3-7
µ¥»÷¡°Ð½¨¡±°´Å¥£¬ÐÞ¸ÄË÷ÒýÃûΪ¡°IX-Class¡±²¢ÇÒÐÞ¸ÄÁÐÃûΪ¡°Clno¡±£¬ÈçÏÂͼ3-8Ëùʾ¡£
µÚ 27 Ò³ ¹² 50 Ò³
ͼ3-8
¹Ø±Õ²¢±£´æ£¬Ìí¼ÓË÷ÒýÍê³É¡£ 7) ɾ³ýÃûΪ IX-ClassµÄË÷Òý
ÈçÉÏͼ3-8Ëùʾ£¬µã»÷¡°É¾³ý¡±°´Å¥¡£É¾³ý¡°IX-Class¡±Ë÷Òý¡£Íê³Éɾ³ýË÷Òýɾ³ý¡£
2. ÒÀ¾ÝÉÏÊöµÄËĸö±í£¬ÓÃSQLÓï¾äÍê³ÉÈçϲéѯ 1) ÕÒ³öËùÓб»Ñ§ÉúÑ¡ÐÞÁ˵Ŀγ̺ţ» ´ò¿ª¡°²éѯ·ÖÎöÆ÷¡±£¬Ñ¡ÔñStudentÊý¾Ý¿â¡£
ÊäÈësqlÓï¾ä£ºselect distinct Cno from Grade£¬ÔÚÏÂÃæ´°¿ÚÏÔʾ²éѯ½á¹ûÈçÏÂͼ3-9Ëùʾ¡£
µÚ 28 Ò³ ¹² 50 Ò³