求助大神一个sql 百分比的问题

Question

select a.cont,CLng((select count(*) as cs from [order] b where b.order_cont like '*'+a.cont+'*'))/CLng((select count(*) from [order] b)) from [order_cont] a

这个输出不出来每一行除完之后的数 求大神帮忙看看这个

Answer 1

因为你是模糊查询，所以用LIKE

SELECT T1.Cont,
SUM(IIF(T2.Order_Cont=T1.Cont, 1, 0))/(SELECT COUNT(*) FROM [Order])
FROM (Order_Cont T1
    LEFT JOIN [Order] T2 ON T2.Order_Cont LIKE '*' + T1.Cont + '*')
GROUP BY T1.Cont