A表
banji yuwen shuxue
一年级一班 100001 100006
一年级二班 100002 100003
一年级三班 100001 100004
一年级四班 100005 100003
一年级五班 100002 100004
一年级六班 100005 100006
B表
laoshixuehao xingming nianling
100001 张三 25
100002 李四 45
100003 王五 28
100004 赵六 50
100005 吴七 40
100006 刘八 48
求sql查询得下表
banji 语文老师姓名 年龄 数学老师姓名 年龄
使用了 如下,结果不行。求助
select *****
from A as yu,a as shu,b
where
yu.yuwen = b.laoshixuehao
or shu.shuxue = b.laoshixuehao
banji yuwen shuxue
一年级一班 100001 100006
一年级二班 100002 100003
一年级三班 100001 100004
一年级四班 100005 100003
一年级五班 100002 100004
一年级六班 100005 100006
B表
laoshixuehao xingming nianling
100001 张三 25
100002 李四 45
100003 王五 28
100004 赵六 50
100005 吴七 40
100006 刘八 48
求sql查询得下表
banji 语文老师姓名 年龄 数学老师姓名 年龄
使用了 如下,结果不行。求助
select *****
from A as yu,a as shu,b
where
yu.yuwen = b.laoshixuehao
or shu.shuxue = b.laoshixuehao
解决方案 »
- 分页显示数据的时候没法显示,数据也添加表中了,不知道怎么回事?
- 高分求job,修改更新sql语句写出job.
- 请教。用sql表达出连续数据分组,并统计分段中数记录数,起、止等信息
- 【觅秘】请问一下在客户段PL/SQL中DML语句(INSERT/UPDATE/DELETE),经办时间是以服务器时间计入系统数据库,还是以客户端时间计入系统数据库??
- 在PL/SQL中,有没有方法知道当前调用的包名以及过程名称?
- 请各位高手帮忙解决!!!!关于触发器的问题!!!!
- 如何在oracle reports中使用动态SQL做数据源(急)
- oracle case的写法
- 执行带有临时表的存储过程为什么出错
- 什么叫动态数据库,什么叫静态数据库啊?
- 求神龙附体
- 数据库接口规范
(select b.xingming from b where a.yuwen = b.laoshixuehao) 语文老师姓名,
(select b.nianling from b where a.yuwen = b.laoshixuehao) 年龄,
(select b.xingming from b where a.shuxue = b.laoshixuehao) 数学老师姓名,
(select b.nianling from b where a.shuxue = b.laoshixuehao) 年龄
from a
select A.banji,B.xingming as yuwen_xingming ,B.nianling as yuwen_nianling
C.xingming as shuxue_xingming ,C.nianling as shuxue_nianling
from A, B, B C
where A.yuwen=B.laoshixuehao and A.shuxue=C.laoshixuehao;
select A.banji,B.xingming as yuwen_xingming ,B.nianling as yuwen_nianling,
C.xingming as shuxue_xingming ,C.nianling as shuxue_nianling
from A, B, B C
where A.yuwen=B.laoshixuehao and A.shuxue=C.laoshixuehao;
MAX(CASE
WHEN A.YUWEN = B.LAOSHIXUEHAO THEN
B.XINGMING
END) 语文老师姓名,
MAX(CASE
WHEN A.YUWEN = B.LAOSHIXUEHAO THEN
B.NIANLING
END) 语文老师年龄,
MAX(CASE
WHEN A.SHUXUE = B.LAOSHIXUEHAO THEN
B.XINGMING
END) 数学老师姓名,
MAX(CASE
WHEN A.SHUXUE = B.LAOSHIXUEHAO THEN
B.NIANLING
END) 数学老师年龄
FROM A_CLASS A,B_TEACHER B
GROUP BY A.BANJI;
C.xingming as shuxue_xingming ,C.nianling as shuxue_nianling
from A, B, B C
where A.yuwen=B.laoshixuehao and A.shuxue=C.laoshixuehao;
max (decode( a.yuwen,b.laoshixuehao , b.nianling ))年龄,
max (decode( a.shuxue,b.laoshixuehao , b.xinming ))数学老师,
max (decode(a.shuxue,b.laoshixuehao , b.nianling ))年龄
from a,b group by banji order by banji