CARLJOSEPHLEE

分类

题解(26)

/ 注册

全部文章（共209篇）

题解 | 查找年龄大于24岁的用户信息

select device_id,gender,age,university from user_profile where age > 24

2025-07-18

1 20

题解 | 查找学校是北大的学生信息

select device_id,university from user_profile where university = "北京大学"

2025-07-18

1 21

题解 | 将查询后的列重新命名

select device_id user_infos_example from user_profile limit 2

2025-07-18

1 20

题解 | 查询结果限制返回行数

select device_id from user_profile limit 2

2025-07-18

1 21

题解 | 查询结果去重

select distinct university from user_profile

2025-07-18

1 22

题解 | 查询多列

select device_id,gender,age,university from user_profile

2025-07-18

1 16

题解 | 查询所有列

@烤点老白薯(637174235)我要开始刷SQL了，准备按顺序刷五百道，白薯哥来吗 SELECT * FROM user_profile

2025-07-18

1 24

题解 | 牛牛的数学作业

from sys import stdin,stdout,setrecursionlimit from math import * from functools import * from bisect import bisect_left input = stdin.readline # prin...

2025-07-17

1 20

题解 | 左侧严格小于计数

from sys import stdin from bisect import bisect_left input = stdin.readline class BIT: def __init__(self, size): self.n = size se...

2025-07-17

1 23

题解 | 神秘石像的镜像序列

很难不忍住一句话@烤点老白薯(637174235) print(" ".join(reversed(input().split()[:-1])))

2025-07-17

1 21