创建表
create table emp
(
empno int ,
ename varchar(10) ,
job varchar(9) ,
mgr int,
hierdate datetime ,
sal decimal(7,2),
comm decimal(7,2),
deptno int,
)
插入数据
insert into emp values (7369,'smith','clerk',7902,'1980/12/17',800.00,null,20)
insert into emp values (7499,'allen','salesman',7698,'1981/2/20',1600.00,300.00,30)
insert into emp values (7521,'ward','salesman',7698,'1981/2/22',1250.00,500.00,30)
insert into emp values (7566,'jones','manager',7839,'1981/4/2',2975.00,null,20)
insert into emp values (7654,'martin','salesman',7698,'1981/9/28',1250.00,1400.00,30)
insert into emp values (7698,'blake','manager',7839,'1981/5/1',2850.00,null,30)
insert into emp values (7782,'clark','manager',7839,'1987/6/9',2450.00,null,10)
insert into emp values (7788,'socctt','analyst',7566,'1987/4/19',3000.00,null,20)
insert into emp values (7844,'turner','salesman',7698,'1981/9/8',1500.00,0.00,30)
insert into emp values (7876,'adams','clerk',7788,'1987/5/23',1100.00,null,20)
insert into emp values (7900,'james','clerk',7698,'1981/12/3',950.00,null,30)
insert into emp values (7902,'foro','analyst',7566,'1981/1/23',3000.00,null,10)
insert into emp values (7934,'miller','clerk',7782,'1982/1/23',1300.00,null,10)
1、显示一个月为30天的情况所有员工的日薪金，忽略余数
2、以年月日方式显示所有员工的服务年限
1、显示一个月为30天的情况所有员工
可能因为工作的原因 接触数据库这块比较少，之前都是做程序这块，数据库这块都有专门的人来做 分工都很明细 所以对数据库这一块完全不了解。前段时间 去面试了几家公司 几乎都是在数据库这块挂掉的 连个简单的SQ ......
