Samuele Locatelli
115a9c3cc3
- Update conf sqlScripts - migration x TaskExec - views/stored creation (maybe)
8 lines
168 B
SQL
8 lines
168 B
SQL
-- creazione viste
|
|
DROP VIEW IF EXISTS v_ParetoStatus;
|
|
|
|
CREATE VIEW v_ParetoStatus AS
|
|
SELECT CodStatus,SUM(Duration) AS TotDuration
|
|
FROM StatusLog
|
|
GROUP BY CodStatus;
|