SQL code:
create table student (sid varchar(10),sname varchar(10),sage varchar(10),ssex varchar(10))
create table Sc (sid varchar(10),cid varchar(10),score int)
insert into sc select '0001','001',80
insert into sc select '0001','001',90
insert into sc select '0001','002',70
insert into sc select '0001','003',85
insert into sc select '0002','001',50
insert into sc select '0003','001',60
insert into sc select '0003','002',70
insert into sc select '0004','001',60
insert into sc select '0004','002',70
insert into sc select '0004','003',80
insert into sc select '0004','004',90
insert into student select '0001','swichin','26','ÄÐ'
insert into student select '0002','lamh','27','ÄÐ'
insert into student select '0003','ballack','34','ÄÐ'
insert into student select '0004','lucio','32','ÄÐ'
²éѯÓëijѧÉúѧµÄÒ»Ñù»òÕ߸ü¶àµÄ¿Î³ÌµÄѧÉú
±ÈÈçѧÉú0001ѧϰÁË 001£¬002£¬003¿Î³Ì
ÄÇô·ûºÏÌõ¼þµÄѧÉúÖ»ÓÐ0004ÕâÒ»¸öÁË
select sname from student where ¿Î³ÌID£¨²»ÖªµÀÄĸö´ú±í¿Î³Ì£©= 001or¿Î³ÌID=002or¿Î³ÌID=003 Ó¦¸ÃÊÇÕâÑù£¬ºÇºÇ ²»Ì«È·¶¨ ÄãÊÔһϰÉ~~~
¶ÔÁË ÄǸösc±í²»·ûºÏ·¶Ê½£¬ ¼ÓÒ»¸öѧÆÚÁаÉ
ÕâÑù sid£¬class£¬Ñ§ÆÚ Èý¸öÁÐ×÷ΪÁªºÏÖ÷¼ü
SQL code:
--> Éú³É²âÊÔÊý¾Ý±í: [tb]
IF OBJECT_ID('[student]') IS NOT
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......