weixin_42313065的博客

@sql 1.比率 SELECT test.A, ROUND( COUNT( CASE WHEN test.B LIKE "%A%" THEN 1 END ) / COUNT( 1 ) * 100, 2 ) AS A FROM test 2.字段为null返回‘其他’，及查询总数 SELECT COALESCE(rs.nationality, '总数' ) nation...

1.依赖 <!-- https://mvnrepository.com/artifact/com.monitorjbl/xlsx-streamer --> <dependency> <groupId>com.monitorjbl</groupId> <artifactId...