SQL 笔记

SQL笔记

1 2	select 月工资 from zg

1 2	select * from ck

1 2	select 职工号,月工资 from zg where 月工资>2000

1
2
3

select 仓库号,城市
from ck
where 面积>400 and 面积<550

1 2	select 仓库号 from ck where 城市='广州'

1
2
3

select count(仓库号)
from ck
where 城市='广州'

1 2	select avg(月工资) from zg

1 2	select count(仓库号) from zg where 仓库号='WH5'

1 2	select distinct 仓库号 from zg

1
2
3

select 仓库号,count(*)人数
 from zg
group by 仓库号

select 仓库号,面积
 from ck
where 城市='上海'
order by 面积 desc

1
2
3

 select 仓库号,count(职工号)人数
from zg where 性别='女'
group by 仓库号 having count(职工号)>3

select 职工号,姓名,性别,月工资
from zg
where 姓名 like'胡%'
order by 性别 desc,月工资 asc

1
2
3

select sum(月工资*12) as 年薪
from zg
where 姓名='王玛丽'

1
2
3

select *
from zg
where 仓库号='WH1'or 仓库号='WH2'

1	select 姓名,月工资*12 as 年工资