摘要：
ALTER FUNCTION [dbo].[parseJSON]( @JSON NVARCHAR(MAX))RETURNS @hierarchy TABLE ( element_id INT IDENTITY(1, 1) NOT NULL, /* internal surrogate primary 阅读全文
摘要：
select * from (select borrowId,month(repayDate) months , hasPI from t_repayment) as ord pivot(sum(hasPI) for months in([12],[1],[2],[3]))as p 阅读全文