5db.txt

来自「the original code of the book the princi」· 文本 代码 · 共 40 行

select * from 仓库 where 仓库号 not in(select 仓库号 from 职工)

select * from 职工 where 工资>=any(
 select 工资 from 职工 where 仓库号='wh2'

)

select * from 职工 where 工资>=(

select min(工资) from 职工 where 仓库号='wh2'
)

select * from 职工 where 工资<=any(
 select 工资 from 职工 where 仓库号='wh2'
)

select * from 职工 where 工资<=
(select max(工资) from 职工 where 仓库号='wh2')

select * from 职工 where 工资>=all(
select 工资 from 职工 where 仓库号='wh1'

)

select * from 职工 where 工资>=
(select max(工资) from 职工 where 仓库号='wh1')

select * from 职工 where 工资<=all
(select 工资 from 职工 where 仓库号='wh1')

select * from 职工 where 工资<=all
(select  min(工资) from 职工 where 仓库号='wh1')

select * from 职工 where 工资>all
(select avg(工资) from 职工 group by 仓库号)

select top 3 * from 职工 
order by 工资 desc

select top 40 percent * from 订购单 order by 金额 asc