用sql语句想要得到字段的百分比

2025-03-05 10:43:51
推荐回答(1个)
回答1:

select * from ((select count(*) from table where Q_TYPE=1 and Q_ONE =0 ) /(select count(*) from table where Q_TYPE=1)) * 100%