![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库SQL实战
流年里不舍的执着
Life is what you make it, so try to make it beautiful
展开
-
数据库SQL实战之内连接(inner join),左连接(left join),右连接(right join),全连接(full join)
person 表IDPlastNameFirstnameAddressCity1AdamsJohnOxford StreetLondon2BushGeorgeFirth AvenueNew York3CarterThomasChangan StreetBeijingorders表IdOOrderNoIdP...原创 2019-10-13 21:48:09 · 221 阅读 · 0 评论 -
数据库SQL之实战distinct和group by
题目描述查找入职员工时间排名倒数第三的员工所有信息CREATE TABLE employees (emp_no int(11) NOT NULL,birth_date date NOT NULL,first_name varchar(14) NOT NULL,last_name varchar(16) NOT NULL,gender char(1) NOT NULL,hire_da...原创 2019-10-11 13:15:50 · 450 阅读 · 0 评论