sql语句面经手撕（定制整理版）

潮_

已于 2025-05-23 22:56:12 修改

阅读量488

点赞数 8

CC 4.0 BY-SA版权

分类专栏：手撕定制整理版我的学习记录文章标签：数据库 sql

于 2025-05-12 23:38:57 首次发布

本文链接：https://blog.csdn.net/chao_789/article/details/147907232

我的学习记录同时被 2 个专栏收录

175 篇文章

订阅专栏

手撕定制整理版

6 篇文章

订阅专栏

一张表店铺id 商品id 销售数量问：查询总销售数量最多的店铺

SELECT 
    shop_id,
    SUM(quantity) AS total_quantity
FROM 
    sales
GROUP BY 
    shop_id
ORDER BY 
    total_quantity DESC
LIMIT 1;

学生总分名最高的

SELECT 
    student_id,
    SUM(score) AS total_score
FROM 
    scores
GROUP BY 
    student_id
ORDER BY 
    total_score DESC
LIMIT 1;

输出年龄大于20的学生年龄；更新表内所有年龄从18到20

只记得查询部分，面试官提了要用update set，但怕说错语法

SELECT age FROM students WHERE age > 20;


UPDATE students SET age = 20 WHERE age = 18;

a表里学生id, name，b表学生id, record，要求查询id, name, record并且按照id降序排列

SELECT 
    a.id, 
    a.name, 
    b.record
FROM 
    a
JOIN 
    b ON a.id = b.id
ORDER BY 
    a.id DESC;

学生表 student
id name chinese  math     english
1  john  90       80       70
2  tom   100      85       90
3  lily  80       70       70
4  jerry 90       60       60


1、按语文分数排序
select * from student order by chinese
2、求数学成绩的和
select sum(math) from student