查询课程编号为“01”的课程比“02”的课程成绩高的所有学生的学号(重点)
思路:将score做自连接 select * from student where s_id in (select distinct ?s1.s_id from score s1 join score s2 on s1.s_id = s2.s_id where s1.c_id = "01&...
1. 查看所有表空间大小 select tablespace_name,(sum(bytes)/1024/1024) tablespace_size from dba_data_files group by tablespace_name; 2. 未使用的表空间大小? select tablespace_name,(sum(bytes)/1024/1024) tablespace_size from dba_free_space group by tablespace...
ImportError: cannot import name ‘soft_unicode’ from 'markupsafe’和ImportError: cannot import name ‘TypedDict’ from ‘typing’ (/opt/module/miniconda3/envs/superset/lib/python3.7/typing.py) 尚硅谷大数据数仓项目superset db upgrade有报错 问题一 Imp...