exam-select-total-by-topic.sql 305 B

12345678910111213
  1. select count(*)
  2. from (select id,
  3. team_name,
  4. topic,
  5. begin_time,
  6. end_time,
  7. score_online,
  8. score_offline,
  9. score_final,
  10. details,
  11. score_report_path
  12. from exam
  13. where topic like ?) temp