![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
胡子球手
谦虚请教
展开
-
sql多列求平均值
mysql SELECT *,CASE WHEN SUM(IFNULL(emp_no_new,0)+IFNULL(emp_no_new_1,0)) =0 THEN 0 ELSE SUM(IFNULL(emp_no_new,0)+IFNULL(emp_no_new_1,0))/ SUM(IF(emp_no_new IS NULL,0,1)+IF(emp_no_new_1 IS NULL,0,1)) END AS avg FROM dept_emp GROUP BY emp_no oracle原创 2022-03-23 21:13:50 · 4422 阅读 · 0 评论 -
sql题(一) 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
drop table if exists salaries ; CREATE TABLE salaries ( emp_no int(11) NOT NULL, salary int(11) NOT NULL, from_date date NOT NULL, to_date date NOT NULL, PRIMARY KEY (emp_no,from_date)); INSERT INTO salaries VALUES(10001,88958,‘2002-06-22’,‘9999-01-01’);原创 2021-12-23 11:34:22 · 701 阅读 · 0 评论