常用SQL

常用SQL
香港考評局程序香港中學文憑
中 

1.抽取 HKDSE各科公開考試成績中 

2.抽取 HKDSE成績
(如老師想要變更科目,只要更換SQL內的考評局科目编碼便可)
中 

EXAMCODE

Exam Year

Class

Class No.

Registration No.

Name

Chinese Name

Gender

A010 Chinese

A010 Reading

A010 Writing

A010 Listening

A010 Speaking

A010 Integrated Skills

A020 English

A020 Reading

A020 Writing

A020 Listening & Integrated Skills

A020 Speaking

A030 Math Compulsory

A040 Liberal Studies

A031 M1

A032 M2

A070 Chinese History

A080 Economics

A090 Ethics and Religious Studies

A100 Geography

A110 History

A130 Biology

A140 Chemistry

A150 Physics

A165 Combined Science

A171 BAFS(Accounting)

A172 BAFS(Business Management)

A180 Design and Applied Technology

A200 ICT

A230 Visual Arts

 

 

3.抽取參加HKDSE學生的選修科及應用學習科的資料中 

4.抽取HKDSE考試成績(以學生班別排序)中 
examyear Subject Code Subject Name classcode classno regno ENNAME CHNAME sex Subject Grade

5.抽取HKDSE考試(考獲5或5*或5**)學生名單中 
6.抽取HKDSE考試成績(連科目分卷) 中 

修訂日期: