![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
database
尹丫子
点滴积累
展开
-
问题:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregate
问题:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP ...转载 2019-03-14 19:35:45 · 263 阅读 · 0 评论 -
#### 多表查询练习数据
#### 多表查询练习数据- 员工信息表```sql--员工信息表CREATE TABLE emp( empno INT, ename VARCHAR(50), job VARCHAR(50), mgr INT, hiredate DATE, sal DECIMAL(7,2), comm DECIMAL(7,2),...原创 2019-03-15 22:30:19 · 281 阅读 · 0 评论 -
Oracle和plsql developer编码设置
Oracle和plsql developer编码设置 在使用pl/sql developer时,查询出来中文字段显示乱码,因为数据库的编号格式和pl /sql developer的编码格式不统一造成的。selectuserenv('language')fromdual;--查询结果:SIMPLIFIED CHINESE_CHINA.AL32UTF8--修改oracle数...转载 2019-06-19 15:50:47 · 471 阅读 · 0 评论