Data Management

Dear All,

The P.E. teacher requests that he wants the following student data:

Student registration No.

Class Level

Class

Male or Female

Birthday

English Name

Chinese name

How can I obtain these data from Data Management.

Thanks.

 

[parsehtml]<P>You can use the following query :</P> <P>SELECT RegNo, ClassLvl, ClassCode, Sex, DATEFORMAT(Dob, 'DD/MM/YYYY') DOB, EnName, ChName FROM TB_STU_Student WHERE ClassCode &lt;&gt; '' ORDER BY ClassLvl, ClassCode</P>[/parsehtml]

 

The files have been downloaded from Data Management. Thanks very much ThePenguin.