SQL高级查询

修改结果集列名

SELECT id AS '学号','name' AS '姓名'
FROM school.`student`

查询结果按id升序

SELECT *
FROM school.`student`
WHERE id > '2020003'
ORDER BY id ASC

查询结果按id降序

SELECT *
FROM school.`student`
WHERE id > '2020003'
ORDER BY id DESC

指定查询范围（IN）

查询id为 '2020002'或'2020003'或'2020005'的记录

SELECT *
FROM school.`student`
WHERE id IN ( '2020002','2020003','2020005' ) ;

相似查询

查询name以ck开始的记录

SELECT *
FROM school.`student`
WHERE `name` LIKE 'ck%'

查询name以ck结束的记录

SELECT *
FROM school.`student`
WHERE `name` LIKE '%ck'

查询name含有ck的记录

SELECT *
FROM school.`student`
WHERE `name` LIKE '%ck%'

注：通配符%适用于MySQL

最值查询

查询最大id

SELECT MAX(id)
FROM school.`student`