add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
CREATE TABLE [dbo].[GetFinalResult]( [PortionKey] [nvarchar](50) NOT NULL, [GroupID] [int] NULL, [GlobalPnId] [int] NOT NULL, [companyid] [bigint] NULL, [familyid] [int] NULL, [PortionId] [int] NOT NULL ) ON [PRIMARY] INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'_', 7, 26108, 1039070, 6030685, 3879063) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'0603', 1, 26108, 1039070, 6030685, 3879049) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'100', 5, 26108, 1039070, 6030685, 3880479) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'101', 3, 26108, 1039070, 6030685, 3879102) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'101', 5, 26108, 1039070, 6030685, 3880476) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'102', 3, 26108, 1039070, 6030685, 3879109) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'103', 3, 26108, 1039070, 6030685, 3879120) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'104', 3, 26108, 1039070, 6030685, 3879130) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'105', 3, 26108, 1039070, 6030685, 3879140) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'106', 3, 26108, 1039070, 6030685, 3879143) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'124', 3, 26108, 1039070, 6030685, 3879131) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'151', 3, 26108, 1039070, 6030685, 3879103) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'152', 3, 26108, 1039070, 6030685, 3879110) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'153', 3, 26108, 1039070, 6030685, 3879121) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'154', 3, 26108, 1039070, 6030685, 3879132) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'160', 5, 26108, 1039070, 6030685, 4499632) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'182', 3, 26108, 1039070, 6030685, 3879111) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'183', 3, 26108, 1039070, 6030685, 3879122) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'184', 3, 26108, 1039070, 6030685, 3879133) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'201', 5, 26108, 1039070, 6030685, 3879057) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'221', 3, 26108, 1039070, 6030685, 3879104) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'222', 3, 26108, 1039070, 6030685, 3879112) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'223', 3, 26108, 1039070, 6030685, 3879123) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'224', 3, 26108, 1039070, 6030685, 3879134) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'225', 3, 26108, 1039070, 6030685, 3879141) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'226', 3, 26108, 1039070, 6030685, 5999945) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'250', 5, 26108, 1039070, 6030685, 3880477) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'272', 3, 26108, 1039070, 6030685, 3879113) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'273', 3, 26108, 1039070, 6030685, 3879124) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'274', 3, 26108, 1039070, 6030685, 3879135) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'301', 5, 26108, 1039070, 6030685, 3880478) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'331', 3, 26108, 1039070, 6030685, 3879105) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'332', 3, 26108, 1039070, 6030685, 3879114) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'333', 3, 26108, 1039070, 6030685, 3879125) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'334', 3, 26108, 1039070, 6030685, 3879136) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'392', 3, 26108, 1039070, 6030685, 3879115) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'393', 3, 26108, 1039070, 6030685, 3879126) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'471', 3, 26108, 1039070, 6030685, 3879106) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'472', 3, 26108, 1039070, 6030685, 3879116) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'473', 3, 26108, 1039070, 6030685, 3879127) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'474', 3, 26108, 1039070, 6030685, 3879137) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'475', 3, 26108, 1039070, 6030685, 3879142) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'500', 5, 26108, 1039070, 6030685, 3880475) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'562', 3, 26108, 1039070, 6030685, 3879117) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'563', 3, 26108, 1039070, 6030685, 3879128) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'564', 3, 26108, 1039070, 6030685, 3879138) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'681', 3, 26108, 1039070, 6030685, 3879107) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'682', 3, 26108, 1039070, 6030685, 3879118) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'683', 3, 26108, 1039070, 6030685, 3879129) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'684', 3, 26108, 1039070, 6030685, 3879139) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'6R3', 5, 26108, 1039070, 6030685, 5999950) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'821', 3, 26108, 1039070, 6030685, 3879108) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'822', 3, 26108, 1039070, 6030685, 3879119) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'A', 8, 26108, 1039070, 6030685, 3879065) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'-A', 8, 26108, 1039070, 6030685, 4643204) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'B', 2, 26108, 1039070, 6030685, 3879051) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'B', 8, 26108, 1039070, 6030685, 3879066) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'-B', 8, 26108, 1039070, 6030685, 4643205) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'Blank', 8, 26108, 1039070, 6030685, 4499631) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'C', 8, 26108, 1039070, 6030685, 3879067) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'-C', 8, 26108, 1039070, 6030685, 4643203) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'F', 4, 26108, 1039070, 6030685, 3879052) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'G', 4, 26108, 1039070, 6030685, 3879053) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'G', 6, 26108, 1039070, 6030685, 3879062) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'J', 4, 26108, 1039070, 6030685, 3879054) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'K', 4, 26108, 1039070, 6030685, 3879055) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'M', 4, 26108, 1039070, 6030685, 3879056) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'S', 6, 26108, 1039070, 6030685, 3879060) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'SN', 6, 26108, 1039070, 6030685, 3879061) INSERT [dbo].[GetFinalResult] ([PortionKey], [GroupID], [GlobalPnId], [companyid], [familyid], [PortionId]) VALUES (N'X', 2, 26108, 1039070, 6030685, 3879050)
70 rows affected