oracle查询字段的同时查询一列的总和

  • Post author:
  • Post category:其他


select t.examinee_id,
t.batch_id,
t.signcompany,
t.signcompany_code,
t.signposition,
t.signposition_code,
(select count(*) from ti_examinee_info b where t.examinee_id=b.examinee_id) as examsum
from ti_examinee_info t



版权声明:本文为wengsibo原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。