基本查询
--查询所有列所有行
-- * 代表查询所有列,未加限制条件说明查找所有行
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/Starry-blog/p/16797307.html