牛客207221769号

分类

题解(2)

/ 注册

全部文章（共57篇）

题解 | #员工的拼接起来作为Name#

select concat(last_name," ",first_name) from employees

2024-02-02

0 163

题解 | #获取当前薪水第二多的员工以及其对应的薪水#

select emp_no,salary from salaries where salary = ( select salary from salaries order by salary desc limit 1 offset 1 ) order by emp_no

2024-02-02

0 250

题解 | #查找employees表的员工信息#

select * from employees where emp_no%2=1 AND last_name != "Mary" order by hire_date desc

2024-02-02

1 210

题解 | #获取所有非manager的员工emp_no#

select emp_no from employees where emp_no not in ( select emp_no from dept_manager )

2024-02-02

0 187

题解 | #找出所有员工当前薪水salary情况#

select distinct salary from salaries order by salary desc

2024-02-02

0 158

题解 | #查找薪水记录超过15条的员工和记录次数t#

select emp_no,count(*) t from salaries group by emp_no having t >15

2024-02-02

0 187

题解 | #查找所有已经分配部门的员工的#

select last_name,first_name,dept_no from employees right join dept_emp using(emp_no)

2024-02-02

0 175

题解 | #最大连续回答问题天数大于等于3天的用户#

with t1 as( select answer_date, author_id, dense_rank() over(partition by author_id order by answer_date) rn from answ...

2024-02-01

0 216

题解 | #某乎问答单日回答问题数大于等于3个的所有用户#

select answer_date,author_id,count(1) answer_cnt from answer_tb group by answer_date,author_id having answer_cnt>=3 order by answer_date,author_id

2024-02-01

0 133

题解 | #某乎问答高质量的回答中用户属于各级别的数量#

select level_cut,count(1) num from( select case when author_level >= 5 then "5-6级" when author_level >= 3 the...

2024-02-01

0 165