查询所属老师名称为“Mike”的全部学生

admin

数据库中：

表Teacher属性：NAME,TID,DESC,

表Student属性：NAME,SID,FK_RELATED_TID,DESC,

查询所属老师名称为“Mike”的全部学生

Cracia

select * from (select TID from Teacher where Name="Mike")t,Student where t.TID=student.FK_RELATED_TID

zhangjialong

create table teacher1(
    name varchar2(8),
    tid varchar2(8),
    --当出现关键字作为属性时，用双引号引起来""表示属性
    "desc" varchar2(8)
);

create table student1(
    name varchar2(10),
    sid varchar2(8),
    fk_related_tid varchar2(8),
    --当出现关键字作为属性时，用双引号引起来""表示属性
    "desc" varchar2(8)
);
select s.name,s."desc"
from teacher1 t,student1 s
where t.tid=s.fk_related_tid and t.name='Mike'

XIAOC

select stu.name

from student stu,teacher te

where stu.desc=te.desc and te.name='Mike';

song

select  s.name

from student s,teacher t

where s.tid=t.tid and t.name='Mike'

WR

PURge recyclebin
--先筛选后关联 从左向右
create table teacher(
       name varchar2(20),
       tid varchar2(20),
       "desc" varchar2(20)
);
create table student2(
       name varchar2(20),
       sid varchar2(20),
       fk_related_tid varchar2(20),
       "desc" varchar2(8)
);
select *
  from teacher t, student2 s
 where t.tid = s.fk_related_tid
   and t.name = 'mike'

一个人的时光

select *
  from t_student s, t_teacher t, t_tsrel ts
 where t.name = (select name from t_teacher t where t.name = 'zhang')
   and s.sid = ts.sid
   and t.tid = ts.tid;

马鹏磊

select *

from teacher t,student s

where t.tid=s.fk_related_tid

and t.name="mike"

renmihe

--创建教师表
create table teacher(
name varchar2(10),
tid  varchar2(8),
"desc" varchar2(8)
);
--创建学生表
create table student(
name varchar2(10),
sid  varchar2(8),
fk_related_tid varchar2(8),
"desc" varchar2(8)
);
--插入数据
insert into teacher values('Mike','1','1001');
insert into teacher values('Mke','2','1002');
insert into teacher values('Mik','3','1003');

insert into student values('Ml','01','1','1001');
insert into student values('xi','02','1','1002');
insert into student values('yd','03','3','1003');
insert into student values('j','04','1','1004');
insert into student values('tu','05','2','1005');
--提交
commit;

--查询所属老师名称为“Mike”的全部学生
select s.name,s."desc"
from teacher t,student s
where t.tid=s.fk_related_tid and t.name='Mike'

liufangyuan

--查询所属老师名称为“Mike”的全部学生
select s.name from
(select tid from teacher where name='Mike')t,student s
where s.ttid=t.tid

-- Create table

create table TEACHER
(
  NAME VARCHAR2(20),
  TID  VARCHAR2(20) not null,
  DES  VARCHAR2(20)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table TEACHER
  add constraint TID primary key (TID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

-- Create/Recreate primary, unique and foreign key constraints
alter table STUDENT
  add constraint SID primary key (SID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table STUDENT
  add constraint TTID foreign key (TTID)
  references TEACHER (TID);

--查询所属老师名称为“Mike”的全部学生
select s.name from
(select tid from teacher where name='Mike')t,student s
where s.ttid=t.tid

gaoye

select Teacher.name,Student.name

from Teacher,Student

where Student.DESC=Teacher.DESC

Sarbr

select *

from Teacher t,Student s

where t.TID=s.FK_RELATED_TID

and t.NAME='Mike'

梦紫菱0124

select * from student where FK_RELATED_TID = (select name from teacher where name="Mike")

CDS 123

select * from Teacher t , Student s where t.tid=s.fk_related_tid and t.name='mike';

李世泽

select s.*from teacher t,stuendt s where t.FK_RELATED_TID=TID and t.name=“Mike”;

740317431

select  s.name

from Teacher t,student s

where s.FK_RELATED_TID=t.TID and

t.name='Mike';

 

王之神判

select s.name

from teacher t,student s

where t.tid=s.FK_RELATED_TID and t.name='Mike'

wulinan

select s.*
from teacher t,student s
where t.tid=s.FK_RELATED_TID and t.name='mike'

郭依凡

select s.name ， s.“desc”

form teacher t，student s

where t.tid=fk-related-tid and t.name=‘Mike’

灰羽

A

yanghao

select s.* from teacher t, student s where t.desc=s.desc and t.name='Mike';

moon110

select t1.NAME, t2.* from Teacher t1

left join Student t2 on t1.RELATED_TID=t2.TID

where t1.NAME='Mike'

m1359292934

select s.name,wm_count(s.name) from teacher t,student s where teacher='mike' group by t.name 

select * from student join teacher on student.fk_related_tid = teacher.tid where teacher.name = ' Mike';