select cast(round((
(select count(job_id) from employee where working_state='Y' and gender='男')*1.0
/ (select count(job_id) from employee where working_state='Y')*1.0),4)*100 as real)
...全文
7705打赏收藏
RDLC报表的问题
怎么将sql中查询的单个数字放入RDLC的单元格中? 搜了很多例子,都是直接把数据库中的某个表放入RDLC中显示。。。 select cast(round(( (select count(job_id) from employee where working_state='Y' and gender='男')*1.0 / (select count(job_id) from employee where working_state='Y')*1.0),4)*100 as real)