SELECT id,yuangongname,bumenTableId FROM yuangong WHERE word = '职员';
找出1部门的经理、2部门的职员 的员工信息。
SELECT * FROM yuangong WHERE id in(SELECT id FROM yuangong WHERE bumenTableId=1 AND word LIKE '%经理')
|| id in (SELECT id FROM yuangong WHERE bumenTableId=2 AND word = '职员')
找出1部门的经理、2部门的职员 或者既不是经理也不是职员但是工资高于2000元的员工信息
SELECT * FROM yuangong WHERE id in (
SELECT id FROM yuangong WHERE id in (SELECT id FROM yuangong WHERE bumenTableId=1 AND word LIKE '%经理')
|| id in (SELECT id FROM yuangong WHERE bumenTableId=2 AND word = '职员')
) ||
id in (SELECT id FROM yuangong WHERE word NOT LIKE '%经理' && word !='职员' && wage >2000)
找出获得奖金的员工的工作。
SELECT word FROM yuangong WHERE bonus !=0
返回员工的详细信息并按姓名排序。
SELECT * FROM yuangong , bumenTable WHERE bumenTable.bumenTableid = yuangong.bumenTableId
ORDER BY yuangong.yuangongname
找出姓名以小、王、李开始的员工信息
SELECT * FROM yuangong WHERE yuangongname LIKE '小%' || yuangongname LIKE '王%' || yuangongname LIKE '李%'
#返回拥有员工的部门名、部门号
SELECT bumenTableid,bumenTablename FROM bumenTable WHERE bumenTableid in
(SELECT bumenTableId FROM yuangong GROUP BY bumenTableId)
工资水平多于小刘的员工信息。
SELECT * FROM yuangong WHERE wage >
(SELECT wage FROM yuangong WHERE yuangongname = '小刘')
返回员工姓名及其所在的部门名称。
SELECT yuangongname as 员工姓名,bumenTablename 所在部门 FROM yuangong,bumenTable
WHERE yuangong.bumenTableId = bumenTable.bumenTableid
查询入职时间由高到低的员工编号,姓名,以及所在部门。
SELECT id 员工编号,yuangongname as 员工姓名,bumenTablename 所在部门 FROM yuangong,bumenTable
WHERE yuangong.bumenTableId = bumenTable.bumenTableid ORDER BY entryTime DESC