1.创建表插入数据
create table emp
(
empno int primary key,
ename nvarchar(10),
job nvarchar(10),
sal int
)
insert into emp values (7369,'smith','clerk',800);
insert into emp values (7499,'allen','salesman',1600);
insert into emp values (7521,'ward','salesman',1250);
2.查询emp表中数据
select * from emp
select empno,ename from emp
select ename,sal*12 as "年薪" from emp
select ename,sal as "月薪",sal*12 "年薪",job "工作" from emp