sql语句例题

发布网友发布时间：2022-05-01 11:44

共3个回答

热心网友时间：2022-05-01 13:13

1:
create table s(s# int primary key,sname varchar(20),age int,sex varchar(2);
2:
insert into s values('20070701','lilin',20,'女')
3:
select c#,cname from c where teacher='张老师';
4:select s#,sname from sc where age>23 and sex='男';
5:
select s# from s where(选修课程 in (select 选修课程 from c where tacher='liu考试'))

热心网友时间：2022-05-01 14:31

skndkfjnfkank,fjnsk,gjns,jngkljghnkh,egnka

热心网友时间：2022-05-01 16:06

1.create table S S# char(10),Sname char(20),age integer,sex char(20)
2.insert into S(S#,Sname,age,sex) values('20070101','Li Lin',20,'女')
3.select C#,Cname from C where Teacher='zhang'
4.select S#,Sname from S where age>23 and sex='男'
5.select S# from S inner join SC on S.S#=SC.S# inner join C on SC.C#=C.C# and C.Teacher='Liu'