【在使用mysql数据库使用中，最常用，也最考验mysql功底的是sql查询，】

最新推荐文章于 2024-04-26 13:29:49 发布
最新推荐文章于 2024-04-26 13:29:49 发布
阅读量1.3k 收藏
点赞数
文章标签： mysql sql 数据库 java 开发语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_59600847/article/details/124556539
版权

前言
在使用mysql数据库使用中，最常用，也最考验mysql功底的是sql查询，，sql查询中相对复杂的莫过于子查询。以下这20题是难度依次递增的子查询相关题目。可以用来检验你是否拥有可以使用mysql初级水平的考验！面对疾风吧！！！！(以下题目是sql专家康师傅提供)

表信息
接下来我们大致介绍一下表信息

主要分为员工表EMPLOYEES，部门表DEPARTMENTS，地点表LOCATIONS

EMPLOYEES包含 employee_id 员工id，唯一 first_name 名 last_name 姓 email 邮箱 phone_number 手机号 job_id 职位id salary 奖金 commission_pct 提成，也可以说奖金率 https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%91%AB%E7%99%BE%E5%88%A9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%AC%A7%E4%BA%9A%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E7%8E%AF%E7%90%83%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%87%91%E9%BC%8E%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%96%B0%E7%99%BE%E7%9B%9B%E5%85%AC%E5%8F%B8%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E9%93%B6%E9%92%BB%E5%85%AC%E5%8F%B8%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=99%E5%8E%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E6%9E%9C%E5%8D%9A%E4%B8%9C%E6%96%B9%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%94%B5%E8%AF%9D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%AE%A2%E6%9C%8D%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%BD%91%E7%AB%99%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E7%82%B9%E5%87%BB%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E6%B3%A8%E5%86%8C%E7%BD%91%E5%9D%80%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E5%9C%A8%E7%BA%BF%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91
https://search.bilibili.com/all?keyword=%E5%8D%8E%E7%BA%B3%E5%9B%BD%E9%99%85%E4%B8%8B%E8%BD%BD%E3%80%90%E5%BE%AE%E4%BF%A1q18896217133%E3%80%91manager_id 自己上司的employee_id department_id 部门id
DEPARTMENT包含 department_id 部门id department_name 部门名字 manager_id 自己上司的employee_id location_id 工作地点id
LOCATIONS包含 location_id 工作地点id street_address 地址 postal_code 邮政编码 city 城市 state_province 州省 country_id 国家id
开始
1、查询和小明相同部门的员工姓名和工资。

很明显，easy！要先查询小明的部门，然后用这个部门id去查等于此id的员工姓名和工资
说明一下：所有的面试题目都不是一成不变的，特别是像一线大厂，下面的面试题只是给大家一个借鉴作用，最主要的是给自己增加知识的储备，有备无患。大致内容包括了： 各类大小厂面经真题、Java 集合、JVM、多线程、并发编程、设计模式、Java、MyBatis、ZooKeeper、Dubbo、Elasticsearch、Memcached、MongoDB、Redis、MySQL、RabbitMQ、Kafka、Linux、Netty、Tomcat、spring面试题、spring cloud面试题、spring boot面试题、spring教程 笔记、spring boot教程笔记、最新阿里巴巴开发手册（63页PDF总结）、2022年Java面试手册一共整理了1184页PDF文档。
0

m0_59600847
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用LabVIEW操作ACCESS、MySQL、SQL server数据库实现按照时间段查询数据
02-11
Made by 三易电子工作室 && 易小时课堂。
MySQL数据库使用情况查询，慢SQL日志记录与配置。（常用命令）
01-19
show global status like '... -- 执行select操作的次数 ... ... ... show global status like 'Innodb_rows_read'; -- select 查询返回的行数 show global status like 'Innodb_rows_inserted'; show global status li
SQL中的NULL
码上看世界
02-04 1382
NULL即空值，当一个属性（字段）为NULL时，表示这个属性没有值。对于NULL，因为它不是一种值，只是标识属性是`unknown`，**它是不可比较的**，只有`IS NULL`或`IS NOT NULL`才能匹配属性是NULL的字段。
数据分析师的SQL功底该学到什么程度？
wujiandao的专栏
08-09 535
点击蓝色“有关SQL”关注我哟加个“星标”，天天与10000人一起快乐成长常有朋友问，数据分析师的SQL功底该学到什么程度。今天就先谈谈 T-SQL 中的 Window Function....
mysql数据库引言_MySQL——前言
weixin_28785681的博客
02-28 384
什么决定了双十一的成败？一天之内上千亿元的成交量，可能同一时刻数据库中就在执行上千万条查询，所以双十一的成败，从技术上来说在于数据库！哪些方面会影响数据库的性能呢？1.sql查询速度2.服务器硬件3.网卡流量4.磁盘IOSQL查询速度大量的并发和超高的CPU使用率会导致的问题大量的并发：数据库连接数被挤满！超高的CPU使用率：因CPU资源耗尽而出现宕机！效率低下的SQL，随着访问量增长，QPS和T...
浅谈sql语句在MySQL中的执行过程
aganliang的专栏
04-11 315
1.一条SQL查询语句的执行过程 一条查询语句的执行过程一般是经过连接器、分析器、优化器、执行器等功能模块，最后达到存储引擎。 客户端提交查询sql语句；server层包括：连接器、缓存查询、分析器、优化器、执行器，连接器管理连接，权限验证，缓存可以直接命中即返回，分析器进行词法和语法分析，优化器执行计划生成和索引选择，执行器操作引擎，返回结果；存储引擎存储数据，提供读写接口。 ...
Mysql高级知识概括
weixin_41005188的博客
09-09 1128
Mysql高级知识概括一级目录 一级目录
Mysql数据库使用concat函数执行SQL注入查询
09-10
主要介绍了Mysql数据库使用concat函数执行SQL注入查询,concat函数在SQL注入查询中会有意想不到的作用,本文就起讲解它的使用,需要的朋友可以参考下
Sql查询MySql数据库中的表名和描述表中字段(列)信息
09-09
主要介绍了Sql查询获取MySql数据库中的表名和描述表中列名数据类型,长度,精度,是否可以为null,默认值,是否自增,是否是主键,列描述等列信息
PyQt中使用QtSql连接MySql数据库的方法
09-08
主要介绍了PyQt中使用QtSql连接MySql数据库的方法，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
mysql 的使用笔记 适合已经学过的
皮皮亮的博客
11-21 2014
Mysql使用笔记 数据类型 数据形式 描述 varchar （1-65535） 变长字符串 char（1-255） 定长字符串 text 0-65535个字符（smalltext,tinytext,longtext） 文本数据 int或integer 范围 (0，4 294 967 295) 大整数值 bigint 范围(0，18 446 744 073 709 551 615) 极大整数值 decimal（m,d） 小数值 date 日期值（年 月
Mysql_数据库事务
最新发布
weixin_69252724的博客
04-26 567
事务就是由单独单元的一个或多个sql语句组成，在这个单元中，每个sql语句都是相互依赖的。而整个单独单元是作为一个不可分割的整体存在，类似于化学当中的原子（一种不可分割的最小单位）。往通俗的讲就是，事务就是一个整体，里面的内容要么都执行成功，要么都不成功。不可能存在部分执行成功而部分执行不成功的情况。就是说如果单元中某条sql语句一旦执行失败或者产生错误，那么整个单元将会回滚(返回最初状态)。
一文整理完MySQL关系型数据库相关知识
打代码是一天，不打代码也是一天
04-23 1067
在开发中，数据库是专门用来存取数据的软件。数据库的职责就是管理数据的。根据存取数据的类型分为关系型数据库和非关系型数据库数据存储后呈现出来的效果类似上图的，是关系型数据库数据存储后呈现出来的效果类似上图的，是非关系型数据库。
MySQL--数据的增删改
pzn2506的博客
04-19 679
文中[ ]里面的内容可写可不写文中[ ]里。
MySQL 服务器权限与对象权限
ChinaLiaoTian的博客
04-23 651
MySQL 权限
深入了解MySQL：从基础到特性，全面解读关系数据库管理系统的历史与应用
lph159的博客
04-23 1010
本文全面介绍了MySQL，这是一种广泛使用的开源关系数据库管理系统（RDBMS），由瑞典MySQL AB公司开发，目前由Oracle公司维护。作为一款具有强大后端功能的数据库软件，MySQL在网站建设、商业智能、数据分析等多个领域中发挥着关键作用。文章从MySQL的历史起源、核心特性，到其在实际应用中的广泛用途进行了详细的阐述。特别指出了MySQL的开源性、高性能、高可扩展性、安全性和灵活性等关键特性，并通过实例展示了如何使用MySQL进行数据库的创建和数据管理。
Mysql个人总结
qq_48904250的博客
04-17 860
又来水字数啦，这次主要讲一下MySQL的常用概念，难点的就必须上项目讲解了，而且比较基础面试基本都会问一些，用的话，不少优化都从这里入手。
【MySQL】数据库操作指南：数据类型篇
青竹雾色间.的博客
04-24 695
✨人生如寄，多忧何为 ✨。
Springboot+Vue项目-基于Java+MySQL的海滨体育馆管理系统(附源码+演示视频+LW)
2301_77929081的博客
04-22 756
本文重点阐述了海滨体育馆管理系统的开发过程，以实际运用为开发背景，基于Spring Boot框架，运用了Java技术和MYSQL作为系统数据库进行开发，充分保证系统的安全性和稳定性。本系统界面良好，操作简单方便，通过系统概述、系统分析、系统设计、数据库设计、系统测试这几个部分，详细的说明了系统的开发过程，最后并对整个开发过程进行了总结，实现了海滨体育馆相关信息管理的重要功能。
如何在flink sql中查询关联的mysql数据库中的数据
06-06
在Flink SQL中查询关联的MySQL数据库中的数据，需要通过Flink的Table API或SQL API进行操作。下面是一个基本的示例： 首先，需要在Flink中添加MySQL JDBC驱动程序的依赖项，例如： ```xml <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.22</version> </dependency> ``` 然后，在Flink SQL中创建一个表，并指定与MySQL数据库的连接信息，例如： ```sql CREATE TABLE mysql_table ( id INT, name STRING, age INT ) WITH ( 'connector.type' = 'jdbc', 'connector.url' = 'jdbc:mysql://localhost:3306/test', 'connector.table' = 'test_table', 'connector.driver' = 'com.mysql.jdbc.Driver', 'connector.username' = 'root', 'connector.password' = '123456' ); ``` 在这个示例中，我们创建了一个名为`mysql_table`的表，它连接到MySQL数据库中的`test_table`表。我们指定了MySQL数据库的连接URL、驱动程序、用户名和密码等信息。 接下来，我们可以通过Flink SQL查询这个MySQL表的数据，例如： ```sql SELECT * FROM mysql_table WHERE age > 18; ``` 这个查询将返回`mysql_table`表中所有年龄大于18岁的记录。 需要注意的是，查询MySQL表的性能取决于数据量和查询复杂度等因素，建议进行性能测试和调优。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值