Retrieving Information From DB of the Questionnaire


Query Command:


Command Examples:

    SELECT * FROM questionnaire
    SELECT ID, education FROM questionnaire
    SELECT education, middle, under, post, phd FROM questionnaire order by education
    SELECT question1, count(*) FROM questionnaire group by question1
    SELECT question2, count(*) FROM questionnaire group by question2
    SELECT question3, count(*) FROM questionnaire group by question3
    SELECT question4, count(*) FROM questionnaire group by question4
    SELECT education, count(*) FROM questionnaire1 group by education 
    SELECT question5 FROM questionnaire order by question5
    

Sun Dexian December 2000      Source: inquiry.txt