SQL快速生成少量样例数据

本文用于快速生成样例数据，用于快速测试

1. 样例数据

-- employe
-- +---+-----+------+
-- | id| name|deptno|
-- +---+-----+------+
-- |105|Chloe|     5|
-- |103| Paul|     3|
-- |101| John|     1|
-- |102| Lisa|     2|
-- |104| Evan|     4|
-- |106|  Amy|     6|
-- |107| Ammi|     1|
-- +---+-----+------+
-- department
-- +------+-----------+
-- |deptno|   deptname|
-- +------+-----------+
-- |     3|Engineering|
-- |     2|      Sales|
-- |     1|  Marketing|
-- |     4|   Finnance|
-- +------+-----------+
with e as (
select id,name,deptno 
from values 
         (105,'Chloe',5)
        ,(103,'Paul',3)
        ,(101,'John',1)
        ,(102,'Lisa',2)
        ,(104,'Evan',4)
        ,(106,'Amy',6)
        ,(107,'Ammi',1) e(id,name,deptno)
)
,d as (
select deptno,deptname
from values
 (3,'Engineering')
,(2,'Sales')
,(1,'Marketing')
,(4,'Finnance') d(deptno,deptname)
)
select
  e.*,d.deptname
from e join d on e.deptno=d.deptno

2. 执行结果如下图