工資資料庫

❶ 如何建立計件工資資料庫

/*按照你的要求，比如：6個大類:A,B,C,D,E,F
A類下面有小類A1,A2,單價分別為1,2
B類下面有小類B1,B2,單價分別為3,4
C類下面有小類C1,C2,單價分別為5,6
D類下面有小類D1,D2,單價分別為7,8
E類下面有小類E1,E2,單價分別為9,10
F類下面有小類F1,F2,單價分別為11,12
*/

--設計一個基礎配置表：
create table a(
id varchar2(20),
superid varchar2(20),
discription varchar2(20),
money number(10));

-- 插入數據
insert into a(id,superid,discription,money)VALUES('A1','A','小類A1',1);
insert into a(id,superid,discription,money)VALUES('A2','A','小類A2',2);
insert into a(id,superid,discription,money)VALUES('B1','B','小類B1',3);
insert into a(id,superid,discription,money)VALUES('B2','B','小類B2',4);
insert into a(id,superid,discription,money)VALUES('C1','C','小類C1',5);
insert into a(id,superid,discription,money)VALUES('C2','C','小類C2',6);
insert into a(id,superid,discription,money)VALUES('D1','D','小類D1',7);
insert into a(id,superid,discription,money)VALUES('D2','D','小類D2',8);
insert into a(id,superid,discription,money)VALUES('E1','E','小類E1',9);
insert into a(id,superid,discription,money)VALUES('E2','E','小類E2',10);
insert into a(id,superid,discription,money)VALUES('F1','F','小類F1',11);
insert into a(id,superid,discription,money)VALUES('F2','F','小類F2',12);

-- 例如：輸入工序名"小類C1"查找其單價的sql語句：
SELECT money FROM a WHERE a.discription = '小類C1';

-- 例如：輸入工序名"小類C1"的數量為"100",可以直接計算出工資的sql語句：
SELECT money*100 FROM a WHERE a.discription = '小類C1';

-- 希望對你有幫助