![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
liulizhi1996
这个作者很懒,什么都没留下…
展开
-
牛客网SQL基础强化
牛客网“ python数据分析”专题下“sql基础强化”板块的所有练习解答。原创 2022-11-13 15:35:12 · 494 阅读 · 0 评论 -
牛客网SQL非技术快速入门
SQL1 查询所有列SELECT *FROM user_profileSQL2 查询多列SELECT device_id, gender, age, universityFROM user_profileSQL3 查询结果去重SELECT DISTINCT universityFROM user_profileSQL4 查询结果限制返回行数SELECT device_idFROM user_profileLIMIT 2SQL5 将查询后的列重新命名SE原创 2024-01-24 17:10:22 · 451 阅读 · 0 评论 -
牛客网SQL大厂面试真题(二)
SQL25 某宝店铺的SPU数量SELECT style_id, COUNT(1) AS SPU_numFROM product_tbGROUP BY style_idORDER BY SPU_num DESCSQL26 某宝店铺的实际销售额与客单价SELECT SUM(total_sales_price) AS sales_total, ROUND(AVG(total_sales_price), 2) AS per_transFROM ( SELECT user_id, S原创 2022-05-06 14:52:37 · 498 阅读 · 0 评论 -
牛客网SQL大厂面试真题(一)
SQL1 各个视频的平均完播率SELECT log.video_id, ROUND(SUM(IF(TIMESTAMPDIFF(SECOND, log.start_time, log.end_time) >= info.duration, 1, 0)) / COUNT(1), 3) AS avg_comp_play_rateFROM tb_user_video_log AS log JOIN tb_video_info AS info ON log.video_id = info.video_i原创 2022-05-06 14:45:56 · 1757 阅读 · 0 评论 -
牛客网SQL进阶挑战(二)
SQL27 每类试卷得分前3名SELECT ranking.tag, ranking.uid, ranking.rankingFROM ( SELECT temp.tag, temp.uid, ROW_NUMBER() OVER (PARTITION BY temp.tag ORDER BY temp.max_score DESC, temp.min_score DESC, temp.uid DESC) AS ranking FROM ( SELECT info.ta原创 2022-05-06 14:32:51 · 700 阅读 · 0 评论 -
牛客网SQL进阶挑战(一)
SQL1 插入记录(一)INSERT INTO exam_record(uid, exam_id, start_time, submit_time, score)VALUES ('1001', '9001', '2021-09-01 22:11:12', '2021-09-01 23:01:12', '90'), ('1002', '9002', '2021-09-04 07:01:02', NULL, NULL)SQL2 插入记录(二)INSERT INTO exam_原创 2022-05-06 14:24:16 · 612 阅读 · 0 评论 -
牛客网数据库SQL实战(五)
SQL92商品交易(网易校招笔试真题)SELECT g.id, g.name, g.weight, t.totalFROM goods g JOIN ( SELECT goods_id, SUM(count) AS total FROM trans GROUP BY goods_id) t ON g.id = t.goods_idWHERE t.total > 20 AND g.weight < 50ORDER BY g.id ASC...原创 2021-10-08 16:15:01 · 274 阅读 · 0 评论 -
牛客网数据库SQL非技术快速入门
SQL1查询多列SELECT device_id, gender, age, universityFROM user_profileSQL2查询所有列SELECT *FROM user_profileSQL3查询结果去重SELECT DISTINCT universityFROM user_profileSQL4查询结果限制返回行数SELECT device_idFROM user_profileLIMIT 2SQL5将查询后的列重新命名SE...原创 2021-09-22 20:23:01 · 413 阅读 · 0 评论 -
JDBC连接MySQL数据库初探
一、第一个JDBC程序import java.sql.*;public class Main { public static void main(String[] args) throws ClassNotFoundException, SQLException { // 1. 加载驱动 Class.forName("com.mysql.cj.jdbc.Driver"); // 2. 连接数据库 String url = "原创 2021-08-04 21:07:10 · 704 阅读 · 1 评论 -
牛客网数据库SQL实战(四)
SQL77牛客的课程订单分析(一)SELECT * FROM order_infoWHERE `date` > '2025-10-15' AND `status` = 'completed' AND product_name IN ('C++', 'Java', 'Python')ORDER BY idSQL78牛客的课程订单分析(二)SELECT user_idFROM order_infoWHERE `date` > '2025-10-15' AND `sta...原创 2021-08-03 13:50:49 · 253 阅读 · 0 评论 -
牛客网数据库SQL实战(三)
SQL61对于employees表中,给出奇数行的first_nameSELECT temp.first_nameFROM ( SELECT first_name, ROW_NUMBER() OVER () AS row_no, RANK() OVER (ORDER BY first_name ASC) AS ranking FROM employees) tempWHERE temp.ranking % 2 = 1ORDE.原创 2021-08-03 11:26:57 · 221 阅读 · 0 评论 -
牛客网数据库SQL实战(二)
SQL32将employees表的所有员工的last_name和first_name拼接起来作为NameSELECT CONCAT(last_name, ' ', first_name) AS nameFROM employeesSQL33创建一个actor表,包含如下列信息CREATE TABLE actor ( `actor_id` SMALLINT(5) NOT NULL AUTO_INCREMENT, `first_name` VARCHAR(45) NOT N..原创 2021-08-03 11:16:39 · 350 阅读 · 0 评论 -
牛客网数据库SQL实战(一)
SQL1查找最晚入职员工的所有信息SELECT * FROM employeesWHERE hire_date = ( SELECT MAX(hire_date) FROM employees)SQL2查找入职员工时间排名倒数第三的员工所有信息SELECT * FROM employeesWHERE hire_date = ( SELECT DISTINCT hire_date FROM employees ORDER BY hire_date DESC ..原创 2021-08-03 10:54:33 · 341 阅读 · 0 评论