SQL系列学习笔记
SQL语言学习笔记
题目一
select * from employees where (
select max(hire_date)
) # 错误版本
select * from employees where hire_date = (
select max(hire_date) from employees
) # 正解
题目二
select * from employees order by hire_date desc limited 2,1 # limited无此关键字
sele
原创
2020-12-05 00:07:24 ·
80 阅读 ·
0 评论