sql查询百分比

https://blog.csdn.net/qq_32793985/article/details/114651944

 

sql查询百分比

SELECT
CONCAT( CAST( round( ( 6 / 100 ) * 100, 3 ) AS CHAR ), '%' ) '占比'
FROM
busa_xm_room;

posted @ 2023-04-25 16:36  yinghualeihenmei  阅读(50)  评论(0编辑  收藏  举报