資料庫子查詢:資料庫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。