标签：基本 04 People -- PeopleSalary PeopleSex 查询 select
基本查询
--查询所有列所有行
-- * 代表查询所有列，未加限制条件说明查找所有行
select*from Department
select*from [Rank]
select*from People
--查询员工表中(姓名，性别，月薪)
select PeopleName,PeopleSex,PeopleSalary from People
--查询员工表中(姓名，性别，月薪)并用中文显示列名
select PeopleName 姓名,PeopleSex 性别,PeopleSalary 月薪
from People
--查询员工的地址(过滤掉重复的数据)
select distinct PeopleAddr from People
--假设准备加工资(提高20%)，并且将之前的工资和加薪后的工资显示出来
select PeopleName 姓名,PeopleSex 性别,
PeopleSalary 加薪前工资,PeopleSalary*1.2 加薪后工资
from People
标签：基本,
04,
People,
--,
PeopleSalary,
PeopleSex,
查询,
select
From： https://www.cnblogs.com/rain-blogs/p/16797307.html