秋天的震撼已经感受到了😅😅😅

分类

/ 注册

全部文章（共80篇）

题解 | #刷题通过的题目排名#

select id,number,dense_rank()over(order by number desc) t_rank from passing_number

2023-11-25

0 189

题解 | #出现三次以上相同积分的情况#

select number from grade group by number having count(number)>=3 order by number

2023-11-25

0 212

题解 | case的用法

SELECT e.emp_no, e.first_name, e.last_name, eb.btype, s.salary, CASE WHEN eb.btype = 1 THEN ROUND(s.salary * 0.1, 1) WHEN eb.btype = 2 THEN ...

SQL错题

2023-11-25

0 275

题解 | sum()over()累计求和

select emp_no,salary,sum(salary)over(order by emp_no) running_total from salaries where to_date='9999-01-01'

SQL错题

2023-11-25

1 264

题解 | %是一个运算符，用于返回除法的余数。

/*SELECT first_name FROM ( SELECT first_name, ROW_NUMBER() OVER (ORDER BY first_name) as row_num, ROW_NUMBER() OVER (ORDER BY emp_no) as original_...

SQL错题

2023-11-25

0 461

题解 | not exists

/*select em.emp_no emp_no,birth_date,first_name,last_name,gender,hire_date from employees em left join dept_emp de on em.emp_no=de.emp_no where dept_n...

SQL错题

2023-11-23

0 293

题解 | limit+查询行数 offset+跳过前几行

select * from employees limit 5 offset 5

SQL错题

2023-11-23

0 246

题解 | 聚合函数不能直接在where字句中使用

select avg(salary) avg_salary from salaries where to_date='9999-01-01' and salary>(select min(salary) from salaries where to_date='9999-01-01') and...

SQL错题

2023-11-23

0 307

题解 | SEPARATOR关键字用于指定连接时使用的分隔符

SELECT dept_no, GROUP_CONCAT(emp_no SEPARATOR ',') AS employees FROM dept_emp GROUP BY dept_no;

SQL错题

2023-11-22

0 238

题解 | RIGHT函数：从字符串中提取多个字符（从右开始）

select e.first_name first_name from(select first_name,right(first_name,2) r2 from employees) e order by e.r2

2023-11-22

0 217