5db.txt

the original code of the book the principle and practice in sql server 2005

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