SQL進修筆記二 創立表、拔出數據的語句

SQL進修筆記二 創立表、拔出數據的語句。本站提示廣大學習愛好者：（SQL進修筆記二 創立表、拔出數據的語句）文章只能為提供參考，不一定能成為您想要的結果。以下是SQL進修筆記二 創立表、拔出數據的語句正文

---

創立一個表T_Employee並拔出若干數據

create table T_Employee(FNumber VARCHAR(20),FName VARCHAR(20),FAge int,FSalary NUMERIC(10,2) ,PRIMARY KEY(FNumber));
insert into T_Employee(FNumber,FName,FAge,FSalary) values('DEV001','Tom',25,8300);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('DEV002','Jerry',28,2300.80);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('SALES001','John',23,5000);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('SALES002','Kerry',28,6200);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('SALES003','Stone',22,1200);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('HR001','Jane',23,2200.88);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('HR002','Tina',25,5200.36);
insert into T_Employee(FNumber,FName,FAge,FSalary) values('IT001','Smith',28,3900);
insert into T_Employee(FNumber,FAge,FSalary) values('IT002',27,2800);


年夜家可以查找下 create與insert敕令的應用。