SQL
文章平均质量分 60
jgd28
哔哔
展开
-
JS把SQL記錄行轉列
SQL結果:頁面展示結果:JS:data.rows.forEach(function(row,e){var ppRow=row.fduty+row.fline+row.fprocess;rowIndex = $.inArray(ppRow,rowNums);if(rowIndex==-1){rowNums.push(ppRow);var newRow1={fduty:row.fduty,fline:row.fline,fprocess:row.fprocess,fproduct:row.f原创 2021-03-05 09:44:18 · 150 阅读 · 1 评论 -
PGSQL function,procedure
1、procedure1.1 create:CREATE OR REPLACE PROCEDURE myProc001(site character varying, fweek integer)LANGUAGE plpgsqlAS $procedure$BEGIN sqls;--only execute , no return END;$procedure$;1.2 call: call myProc001('ooodt1 08:00:00',...原创 2021-02-03 17:19:48 · 684 阅读 · 0 评论 -
pgsql 行转列
select fdate::int,iotype,duty,process,0,sum(fqty),0,0, sum(fqty) filter(where fhour='0'),sum(fqty) filter(where fhour='1'), sum(fqty) filter(where fhour='2'),sum(fqty) filter(where fhour='3'), sum(fqty) filter(where ...原创 2021-02-01 13:39:12 · 1952 阅读 · 0 评论