郁闷死了,我有学生表,课程表,和两者的关联表,我怎么查询考试了全部课程的学生啊?
解决方案 »
- 小弟菜鸟 请高手帮帮忙!oracle id自增 触发器无法创建
- 求一SQL语句写法
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP 错误
- oracle
- 帮忙看看这游标嵌套问题 大哥们! 在线等
- 关于SQL developer访问oracle
- 请问这个需求用触发器能否实现
- 备份数据库出错,大家请帮下忙!急
- Oracle8i在CPU为P4(OS is Win2000 Server)配置中不能安装?
- 二维数组赋值问题
- orcale 实体化视图 无法为实体化视图设置 ON COMMIT 刷新属性
- 关于Access导出到Oracle的问题
FROM (
SELECT stu_id, COUNT(*) AS num
FROM (
SELECT '001' AS stu_id, 'A' AS study_id FROM dual
UNION ALL
SELECT '001' AS stu_id, 'B' AS study_id FROM dual
UNION ALL
SELECT '002' AS stu_id, 'B' AS study_id FROM dual
UNION ALL
SELECT '003' AS stu_id, 'A' AS study_id FROM dual
)
GROUP BY stu_id
) stu_a
, (
SELECT COUNT(*) AS num
FROM (
SELECT 'A'AS study_id, '语文' AS study_name FROM dual
UNION ALL
SELECT 'B'AS study_id, '数学' AS study_name FROM dual
)
) study
, (
SELECT '001' AS stu_id, '王明' AS stu_name FROM dual
UNION ALL
SELECT '002' AS stu_id, '李三' AS stu_name FROM dual
UNION ALL
SELECT '003' AS stu_id, '罗斯' AS stu_name FROM dual
) stu
WHERE stu_a.num = study.num
AND stu_a.stu_id = stu.stu_id