SQL SQL輸出科大要求的格式

本文由 開開心心 在 2012-10-15 發表於 "WebSAMS 討論區" 討論區

  1. 10476511

    開開心心
    Expand Collapse

    文章:
    12
    讚:
    0
    科大要求學校提交各科的percentile,格式如下

    Name of Student Class Home Tel No. Mobile No. Email Address Chinese Lang. English Lang. Maths (compul) Liberal Studies Maths (M1) Maths (M2) Physics Chemistry Biology Combined Science Integrated Science Business, Accounting and Financial Studies Economics Chinese History History Geography Info and Comm. Tech. Visual Arts Music Literature in English Chinese Literature Tourism & Hospitality Studies Ethics & Religious Studies Design & Applied Tech. Health Mgt. & Social Care Physical Education Integrated Science Tech. & Living

    percentile的範圍
    Top 10%
    11% - 25%
    26% - 50%
    51% - 75%
    76% - 100%


    請問是否有適合的SQL?
     
    #1 開開心心, 2012-10-15
  2. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
    #2 edb-石頭, 2012-10-17