摘要:
在前人的基础上改进的,原来的代码无法运行。先能用吧。 Date.prototype.format = function (mask) { var d = this; var zeroize = function (value, length) { if (!length) length = 2; v 阅读全文
摘要:
不解释,全靠悟性: select loan_num,row_number() over(order by loan_num asc) as 'Row Number',rank() over(order by loan_num asc) as 'Rank',dense_rank() over(orde 阅读全文
摘要:
SELECT max(CASE TT.groupname WHEN 'A' THEN TT.name end) AS 'nameA',max(CASE TT.groupname WHEN 'A' THEN TT.age end) AS 'ageA',max(CASE TT.groupname WHE 阅读全文