常用SQL

常用SQL
時間表編排(介面) 
中 

1.抽取 時間表 空堂老師中 
Cycle Day Period Teacher ID

2.抽取 時間表數據(如班,老師,室) 中 
LayoutID Class Home Room Name Home Room Code Class Teachers Day Period Length_Len Start_Hour Start_Minute End_Hour End_Minute Duration Subject_E Subject_C Subject_Short_E Subject_Short_C Room Code Room Teacher_S Teacher_E Teacher_C

3.抽取 數據集編號(INSTID) 中 
Instance ID Instance School ID School Year School Level School Session School Name Dataset Name Copy Name Remarks Result Set Name Result Set Remarks Start Date End Date

修訂日期: