摘要:
如果没有加group by 则会出UserCount为0外其它都是null select a.*,count(b.ID) as UserCount from erp_role as a left join erp_user as b on a.ID=b.RoleId where 1=1 and a. 阅读全文
摘要:
sqlserver: #query SELECT SalesOrderNumber, OrderDate, JSON_VALUE(Info, '$.Customer.Name') AS CustomerName FROM Sales.SalesOrderHeader WHERE JSON_VALUE 阅读全文