牛码er

分类

/ 注册

全部文章（共4篇）

题解 | #推荐内容准确的用户平均评分#

select sum(score)/count(user_id) from (select t2.user_id,t2.score from recommend_tb t1 inner join user_action_tb t2 on t1.rec_user=t2.user...

2024-11-02

1 46

题解 | #分析客户逾期情况#

select pay_ability, concat(round(sum(flg)/sum(rs)*100,1),'%')as overdue_ratio #MySQL的某些版本中，如果启用了 PIPES_AS_CONCAT SQL模式，|| 将被视为OR运算符导致结果错误，最好用concat拼接...

2024-11-02

0 56

#获取当前薪水第二多的员工emp_no及薪水salary#

select a.emp_no, a.salary, b.last_name, b.first_name from salaries a inner join employees b on a.emp_no=b.emp_no and a.to_date='9999-01-01' and a.emp...

2024-10-26

0 47

题解 | #查找在职员工自入职以来的薪水涨幅情况#

select a.emp_no,(c.salary-b.salary) as growth from employees a left join salaries b on a.emp_no=b.emp_no and a.hire_date =b.from_dat...

2024-10-25

0 110