数据库子查询:数据库sql语句大全[朗读]

selecta.user_name,a.count1,b.count2,c.mfrom(selectuser_name,count(*)count1frompunch_card_recordwhereto_char(onduty_time,'hh24:mi')>'09:00'groupbyuser_name)a,(selectuser_name,count(*)count2frompunch_card_recordwhereto_char(offduty_time,'hh24:mi')评论000。