Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Tememons Dashboard
BEGIN TRANSACTION; /* Create a table called NAMES */ CREATE TABLE uni_t24( batchname TEXT NOT NULL, stage TEXT NOT NULL, short_stage TEXT NOT NULL, status TEXT NOT NULL, batchdate TEXT NOT NULL, startdate TIMESTAMP , enddate TIMESTAMP , elapsedtime int ); insert into uni_t24 values ( 'SGP/CARD.CHEQUE.EOD-CHEQUE.CHARGE.EOD.POST', 'A700-Application', 'Application', '0', '20150423', '20150423 21:41:45', '20150423 21:41:45', '1'); insert into uni_t24 values ( 'SGP/DX.END.OF.DAY-DX.COB.MARKET.PRICES', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:07', '20150423 21:39:09', '2'); insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-BV.GET.TRANS', 'R045-Reporting', 'Reporting', '0', '20150423', '20150423 22:12:35', '20150423 22:12:36', '1'); insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-BV.RELEASE.LOCKED.SEC.PRICE', 'R045-Reporting', 'Reporting', '0', '20150423', '20150423 22:12:37', '20150423 22:12:38', '2'); insert into uni_t24 values ( 'SGP/EOD.BACKVALUE-EOD.SECURITY.MASTER.HIST', 'R045-Reporting', 'Reporting', '0', '20150423', '20150423 22:12:30', '20150423 22:12:34', '4'); insert into uni_t24 values ( 'SGP/EOD.BENCHMARK.PERF-UPD.CALC.BM.PERF', 'S022-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:58:47', '20150423 21:58:47', '1'); insert into uni_t24 values ( 'SGP/EOD.DATA.CAPTURE-DATA.CAPTURE.EOD', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:05', '20150423 21:39:06', '1'); insert into uni_t24 values ( 'SGP/FILE.TIDY.UP-EB.PRIME.FILES', 'D003-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 22:20:47', '20150423 22:20:47', '1'); insert into uni_t24 values ( 'SGP/FIN.LIMITS.EOD2-UNUTILISED.LIMIT.SWEEP', 'S011-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:44:20', '20150423 21:44:20', '1'); insert into uni_t24 values ( 'SGP/FIN.LIMITS.EOD-COLLATERAL.LIMIT.EOD', 'S021-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:58:42', '20150423 21:58:43', '1'); insert into uni_t24 values ( 'SGP/FT.END.OF.DAY-FT.PROCESS.BULK.PAYMENT.PRE', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:09', '20150423 21:39:09', '1'); insert into uni_t24 values ( 'SGP/FT.START.OF.DAY-FT.INWD.BULK.STO.PAY', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 06:58:20', '20150423 06:58:20', '1'); insert into uni_t24 values ( 'SGP/FT.START.OF.DAY-FT.STO.PAY', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 06:58:19', '20150423 06:58:19', '1'); insert into uni_t24 values ( 'SGP/FX.END.OF.DAY-FX.EOD.AMORTISATION', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:10', '20150423 21:39:10', '1'); insert into uni_t24 values ( 'SGP/FX.END.OF.DAY-FX.NE.PROCESS', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:11', '20150423 21:39:11', '1'); insert into uni_t24 values ( 'SGP/LC.END.OF.DAY-LC.FILES.TIDY.UP', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:13', '20150423 21:39:13', '1'); insert into uni_t24 values ( 'SGP/LC.END.OF.DAY-LC.MATURE', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:12', '20150423 21:39:12', '1'); insert into uni_t24 values ( 'SGP/LD.END.OF.DAY-LD.END.OF.DAY.8', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:14', '20150423 21:39:14', '1'); insert into uni_t24 values ( 'SGP/LD.START.OF.DAY-LD.END.OF.DAY.8', 'D010-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 22:25:12', '20150423 22:25:12', '1'); insert into uni_t24 values ( 'SGP/MD.START.OF.DAY-MD.SOD.ACCRUAL', 'D100-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 06:58:24', '20150423 06:58:24', '1'); insert into uni_t24 values ( 'SGP/MF.SYS.END.OF.DAY-MF.UPD.TOTAL.UNITS.POST', 'S019-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:57:23', '20150423 21:57:24', '1'); insert into uni_t24 values ( 'SGP/MM.END.OF.DAY-MM.EOD.ONLINE.MATURITY', 'A201-Application', 'Application', '0', '20150423', '20150423 21:41:29', '20150423 21:41:29', '1'); insert into uni_t24 values ( 'SGP/MM.START.OF.DAY-MM.START.OF.DAY.2', 'D201-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 12:15:02', '20150423 12:15:02', '1'); insert into uni_t24 values ( 'SGP/PM.BATCH.START-PM.SC.ONITE.POS', 'D920-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 12:19:18', '20150423 12:19:18', '1'); insert into uni_t24 values ( 'SGP/RE.BUILD.SLC-RE.UPDT.STAT.LINE.CONT', 'R001-Reporting', 'Reporting', '0', '20150423', '20150423 22:09:42', '20150423 22:09:53', '11'); insert into uni_t24 values ( 'SGP/RE.BUILD.SLC.WORK-RE.BUILD.SLC.WORK', 'A006-Application', 'Application', '0', '20150423', '20150423 21:29:15', '20150423 21:29:17', '3'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.APPLICATION-EB.EOD.REPORT.PRINT', 'A999-Application', 'Application', '0', '20150423', '20150423 21:43:16', '20150423 21:43:18', '2'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.REPORTING-EB.EOD.REPORT.PRINT', 'R999-Reporting', 'Reporting', '0', '20150423', '20150423 22:20:02', '20150423 22:20:12', '10'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.SOD-EB.EOD.REPORT.PRINT', 'D999-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 12:19:36', '20150423 12:19:37', '1'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.SYSTEM-EB.EOD.REPORT.PRINT', 'S999-System-Wide', 'System-Wide', '0', '20150423', '20150423 22:08:05', '20150423 22:08:06', '1'); insert into uni_t24 values ( 'SGP/RE.UPDATE.SLC.LINE.BAL-RE.UPDATE.LINE.BAL.MVMT', 'R799-Reporting', 'Reporting', '0', '20150423', '20150423 22:15:51', '20150423 22:15:58', '8'); insert into uni_t24 values ( 'SGP/RP.END.OF.DAY-RP.EOD.DETERMINE.ACTIVITY', 'A100-Application', 'Application', '0', '20150423', '20150423 21:39:17', '20150423 21:39:17', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.REP-SC.BATCH.DATE.CYCLE', 'R040-Reporting', 'Reporting', '0', '20150423', '20150423 22:10:17', '20150423 22:10:18', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.ACCR.DATE.UPDATE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 12:19:04', '20150423 12:19:04', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.UPDATE.SM.PRICE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 12:19:04', '20150423 12:19:05', '1'); insert into uni_t24 values ( 'SGP/SC.ONLINE-SC.SOD.APPLY.DEF.INSTR', 'O006-Online', 'Online', '0', '20150423', '20150423 12:20:21', '20150423 12:20:22', '2'); insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.EXTRACT', 'S020-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:57:54', '20150423 21:57:56', '2'); insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.PEND', 'S020-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:57:57', '20150423 21:57:57', '1'); insert into uni_t24 values ( 'SGP/SEAT.SYSTEM.CHECKS-BALANCE.REGISTER', 'D005-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 22:25:01', '20150423 22:25:02', '1'); insert into uni_t24 values ( 'SGP/SL.START.OF.DAY-SL.SOD.PROCESS.SCHEDULES', 'D101-Start-of-Day', 'Start-of-Day', '0', '20150423', '20150423 06:58:40', '20150423 06:58:40', '1'); insert into uni_t24 values ( 'SGP/SYSTEM.END.OF.DAY3-ICA.BLD.ACCT.ACT.CORR', 'S012-System-Wide', 'System-Wide', '0', '20150423', '20150423 21:45:55', '20150423 21:45:55', '1'); insert into uni_t24 values ( 'SGP/UNAUTH.PROCESSING-UNAUTH.PROCESSING', 'A001-Application', 'Application', '0', '20150423', '20150423 21:28:25', '20150423 21:28:25', '3'); insert into uni_t24 values ( 'SGP/RE.BUILD.SLC.WORK-RE.BUILD.SLC.WORK', 'A006-Application', 'Application', '0', '20150422', '20150422 21:29:15', '20150422 21:29:17', '3'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.APPLICATION-EB.EOD.REPORT.PRINT', 'A999-Application', 'Application', '0', '20150422', '20150422 21:43:16', '20150422 21:43:18', '2'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.REPORTING-EB.EOD.REPORT.PRINT', 'R999-Reporting', 'Reporting', '0', '20150422', '20150422 22:20:02', '20150422 22:20:12', '10'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.SOD-EB.EOD.REPORT.PRINT', 'D999-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 12:19:36', '20150422 12:19:37', '1'); insert into uni_t24 values ( 'SGP/REPORT.PRINT.SYSTEM-EB.EOD.REPORT.PRINT', 'S999-System-Wide', 'System-Wide', '0', '20150422', '20150422 22:08:05', '20150422 22:08:06', '1'); insert into uni_t24 values ( 'SGP/RE.UPDATE.SLC.LINE.BAL-RE.UPDATE.LINE.BAL.MVMT', 'R799-Reporting', 'Reporting', '0', '20150422', '20150422 22:15:51', '20150422 22:15:58', '8'); insert into uni_t24 values ( 'SGP/RP.END.OF.DAY-RP.EOD.DETERMINE.ACTIVITY', 'A100-Application', 'Application', '0', '20150422', '20150422 21:39:17', '20150422 21:39:17', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.REP-SC.BATCH.DATE.CYCLE', 'R040-Reporting', 'Reporting', '0', '20150422', '20150422 22:10:17', '20150422 22:10:18', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.ACCR.DATE.UPDATE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 12:19:04', '20150422 12:19:04', '1'); insert into uni_t24 values ( 'SGP/SC.BATCH.START-SC.UPDATE.SM.PRICE', 'D910-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 12:19:04', '20150422 12:19:05', '1'); insert into uni_t24 values ( 'SGP/SC.ONLINE-SC.SOD.APPLY.DEF.INSTR', 'O006-Online', 'Online', '0', '20150422', '20150422 12:20:21', '20150422 12:20:22', '2'); insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.EXTRACT', 'S020-System-Wide', 'System-Wide', '0', '20150422', '20150422 21:57:54', '20150422 21:57:56', '2'); insert into uni_t24 values ( 'SGP/SC.VAL.EXTRACT-WRITE.SC.VAL.PEND', 'S020-System-Wide', 'System-Wide', '0', '20150422', '20150422 21:57:57', '20150422 21:57:57', '1'); insert into uni_t24 values ( 'SGP/SEAT.SYSTEM.CHECKS-BALANCE.REGISTER', 'D005-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 22:25:01', '20150422 22:25:02', '1'); insert into uni_t24 values ( 'SGP/SL.START.OF.DAY-SL.SOD.PROCESS.SCHEDULES', 'D101-Start-of-Day', 'Start-of-Day', '0', '20150422', '20150422 06:58:40', '20150422 06:58:40', '1'); insert into uni_t24 values ( 'SGP/SYSTEM.END.OF.DAY3-ICA.BLD.ACCT.ACT.CORR', 'S012-System-Wide', 'System-Wide', '0', '20150422', '20150422 21:45:55', '20150422 21:45:55', '1'); insert into uni_t24 values ( 'SGP/UNAUTH.PROCESSING-UNAUTH.PROCESSING', 'A001-Application', 'Application', '0', '20150422', '20150422 21:28:25', '20150422 21:28:25', '3'); select count(batchname),short_stage, ROUND(avg(elapsedtime)) as average_time from uni_t24 where batchdate between '20150422' and '20150423' group by short_stage;
run
|
edit
|
history
|
help
0
Select the latest id from last week from each different contact without repeating barcodes .....
Leet Code 185
SQL Practice Sample: Movie Database
E-commerce Website SQL Analysis
testo
Ecommerce Website Analysis by SQL
Select rows with no intersection on join table and check by date
hw
postgresql timestamp
loggin_trigger-audit