SQL 初学

1,

USE 学生库
GO
CREATE TABLE 学生信息表(
学号 INT PRIMARY KEY,
班级 CHAR (6),
姓名 CHAR (8),
性别 CHAR (2),
出生日期 DATETIME,
备注 VARCHAR (50)
);

 

2,

USE salarynew
go
select info_personnel.fid,fname
from info_personnel,info_salary
where info_personnel.fid=info_salary.fid

 

3, <!-- /* Font Definitions */ @font-face {font-family:新細明體; panose-1:2 2 3 0 0 0 0 0 0 0; mso-font-alt:PMingLiU; mso-font-charset:136; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:3 137232384 22 0 1048577 0;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} @font-face {font-family:"/@新細明體"; panose-1:2 2 3 0 0 0 0 0 0 0; mso-font-charset:136; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:3 137232384 22 0 1048577 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:新細明體; mso-font-kerning:1.0pt;} /* Page Definitions */ @page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:18.0pt;} div.Section1 {page:Section1;} --> 当所列出的某个条件为 true 时， OR 运算符会显示记录。当列出的所有条件为 true 时， AND 运算符会显示记录。

 

4,

use salarynew
go
select info_personnel.fid,*
from info_personnel,info_salary
where info_personnel.fid=info_salary.fid and fyear='2010'  and fname='張莉'

 

5,

select titles.pub_id as id,titles.title as title,pub.*
from titles,publishers pub
where titles.pub_id=pub.pub_id

--publishers pub這中間有個AS,被省略了,可以這樣寫.

 

6,group by 分组

   order by 排序