数据库查询

xiaoxiao2021-02-28  107

链表查询,

并且记录答案出现的次数;

SELECT uqsub.title        AS '题目',        uqa.content        as '答题内容',        uqo.name       as'题目选项',          uqa.answerid  as '序号',          uqa.createTime  as '时间',          count(uqa.createTime)  as '次数'     FROM uwin_question_sheet      uqs,      uwin_question_answer     uqa,      uwin_question_subject    uqsub,       uwin_question_option    uqo    WHERE             uqsub.subjectid = uqa.subjectid         and uqo.subjectid = uqa.subjectid     and uqo.sort = uqa.optionid     group by   uqo.name  order by uqa.subjectid      

转载请注明原文地址: https://www.6miu.com/read-66135.html

最新回复(0)