COMMON TABLE EXPRESSIONS

Complex problems may require lengthy code and/or complicated logic to yield the intended result set. As a result, it is often easier to solve complex problems by breaking the problem down into manageable chunks or subproblems. A positive side-effect of this is others and your future self may find the code and underlying strategy easier to understand. Common table expressions (CTE) in Oracle and other relational database management systems provide a method for structuring your code that yields a transparent strategy. CTEs are also often referred to as named, temporary result sets.

Common Use Cases
1. The task at hand requires a lengthy and/or complex temporary result set and is referenced one or more times. CTEs allow you to reuse blocks of code without having to repeat yourself in your code.

2. Multiple questions will be answered using a base data set or foundation. This base data set or foundation is typically a defined subset of a table or multiple tables.

3. There exists a logical grouping or separation of subproblems.

I’ve written two example problems below. My hope is to highlight the advantages of common table expressions by illustrating how they are interwoven with the problem-solving strategy of breaking down a seemingly complex problem into multiple subproblems. After each example, coding solution incorporating CTEs, and output, I also provide a solution not using CTEs for comparison. At the end of this page, I comment on the alternative solutions not using CTEs.

Before reading further, consider reviewing the Example Data section below to familiarize yourself with the data being used throughout the examples on this page. If you are already familiar with the data, then skip to the Problem 1 section.

Example Data
The schemas, corresponding tables, and data used in the example problems can be found at livesql.oracle.com. To more easily follow the examples covered on this page, consider first reading the table descriptions below and reviewing each table’s contents. To review the data maintained in each table, click on the icon next to the table name. To hide the data, click the icon again.

oe.orders
For each order placed by a customer, various attributes are captured. There is one row per order.
order_idorder_dateorder_modecustomer_idorder_statusorder_totalsales_rep_idpromotion_id
245816-AUG-07 03.34.12.234359 PMdirect101078279.6153–
239719-NOV-07 02.41.54.696211 PMdirect102142283.2154–
245402-OCT-07 05.49.34.678340 PMdirect10316653.4154–
235414-JUL-08 06.18.23.234567 PMdirect104046257155–
235808-JAN-08 05.03.12.654278 PMdirect10527826155–
238114-MAY-08 08.59.08.843679 PMdirect106323034.6156–
244031-AUG-07 09.53.06.008765 PMdirect107370576.9156–
235708-JAN-06 08.19.44.123456 PMdirect108559872.4158–
239410-FEB-08 09.22.35.564789 PMdirect109521863158–
243502-SEP-07 11.22.53.134567 PMdirect144662303159–
245520-SEP-07 11.34.11.456789 AMdirect145714087.5160–
237916-MAY-07 02.22.24.234567 AMdirect146817848.2161–
239602-FEB-06 01.34.56.345678 AMdirect147834930161–
240629-JUN-07 04.41.20.098765 AMdirect14882854.2161–
243413-SEP-07 05.49.30.647893 AMdirect1498268651.8161–
243602-SEP-07 06.18.04.378034 AMdirect11686394.8161–
244627-JUL-07 07.03.08.302945 AMdirect1178103679.3161–
244727-JUL-08 08.59.10.223344 AMdirect101833893.6161–
243214-SEP-07 09.53.40.223345 AMdirect1021010523163–
243313-SEP-07 10.19.00.654279 AMdirect1031078163–
235526-JAN-06 09.22.51.962632 AMonline104894513.5––
235626-JAN-08 09.22.41.934562 AMonline105529473.8––
235908-JAN-06 09.34.13.112233 PMonline10695543.1––
236014-NOV-07 12.22.31.223344 PMonline1074990.4––
236113-NOV-07 01.34.21.986210 PMonline1088120131.3––
236213-NOV-07 02.41.10.619477 PMonline109492829.4––
236323-OCT-07 05.49.56.346122 PMonline144010082.3––
236428-AUG-07 06.18.45.942399 PMonline14549500––
236528-AUG-07 07.03.34.003399 PMonline146927455.3––
236628-AUG-07 08.59.23.144778 PMonline147537319.4––
236727-JUN-08 09.53.32.335522 PMonline14810144054.8––
236826-JUN-08 10.19.43.190089 PMonline1491060065––
236926-JUN-07 11.22.54.009932 PMonline116011097.4––
237027-JUN-08 12.22.11.647398 AMonline1174126––
237116-MAY-07 01.34.56.113356 AMonline118679405.6––
237227-FEB-07 12.22.33.356789 AMonline119916447.2––
237327-FEB-08 01.34.51.220065 AMonline1204416––
237427-FEB-08 02.41.45.109654 AMonline12104797––
237526-FEB-07 03.49.50.459233 AMonline1222103834.4––
237607-JUN-07 06.18.08.883310 AMonline123611006.2––
237707-JUN-07 07.03.01.001100 AMonline141538017.8––
237824-MAY-07 08.59.10.010101 AMonline142525691.3––
238016-MAY-07 09.53.02.909090 AMonline143327132.6––
238214-MAY-08 10.19.03.828321 AMonline144871173––
238312-MAY-08 11.22.30.545103 AMonline145836374.7––
238412-MAY-08 12.22.34.525972 PMonline146329249.1––
238508-DEC-07 11.34.11.331392 AMonline1474295892––
238606-DEC-07 12.22.34.225609 PMonline1481021116.9––
238711-MAR-07 03.34.56.536966 PMonline149552758.9––
238804-JUN-07 04.41.12.554435 PMonline1504282694.3––
238904-JUN-08 05.49.43.546954 PMonline151417620––
239018-NOV-07 04.18.50.546851 PMonline15297616.8––
239127-FEB-06 05.03.03.828330 PMdirect153248070.6156–
239221-JUL-07 08.59.57.571057 PMdirect154926632161–
239310-FEB-08 07.53.19.528202 PMdirect155423431.9161–
239502-FEB-06 08.19.11.227550 PMdirect156368501163–
239819-NOV-07 09.22.53.224175 PMdirect15797110.3163–
239919-NOV-07 10.22.38.340990 PMdirect158025270.3161–
240010-JUL-07 01.34.29.559387 AMdirect159269286.4161–
240110-JUL-07 02.22.53.554822 AMdirect1603969.2163–
240202-JUL-07 03.34.44.665170 AMdirect1618600154–
240301-JUL-07 04.49.13.615512 PMdirect1620220154–
240401-JUL-07 04.49.13.664085 PMdirect1636510158–
240501-JUL-07 04.49.13.678123 PMdirect16451233159–
240729-JUN-07 07.03.21.526005 AMdirect16592519155–
240829-JUN-07 08.59.31.333617 AMdirect1661309158–
240929-JUN-07 09.53.41.984501 AMdirect167248154–
241024-MAY-08 10.19.51.985501 AMdirect168645175156–
241124-MAY-07 11.22.10.548639 AMdirect169815760.5156–
241229-MAR-06 10.22.09.509801 AMdirect170966816158–
241329-MAR-08 01.34.04.525934 PMdirect101548552161–
241429-MAR-07 02.22.40.536996 PMdirect102810794.6153–
241529-MAR-06 01.34.50.545196 PMdirect1036310161–
241629-MAR-07 04.41.20.945676 PMdirect1046384160–
241720-MAR-07 05.49.10.974352 PMdirect10551926.6163–
241820-MAR-04 04.18.21.862632 PMdirect10645546.6163–
241920-MAR-07 07.03.32.764632 PMdirect107331574160–
242013-MAR-07 08.59.43.666320 PMdirect108229750160–
242112-MAR-07 09.53.54.562432 PMdirect109172836––
242216-DEC-07 08.19.55.462332 PMdirect144211188.5153–
242321-NOV-07 10.22.33.362632 AMdirect145310367.7160–
242421-NOV-07 10.22.33.263332 AMdirect146413824153–
242516-NOV-06 11.34.22.162552 PMdirect14751500.8163–
242617-NOV-06 12.22.11.262552 AMdirect14867200––
242710-NOV-07 01.34.22.362124 AMdirect14979055163–
242810-NOV-07 02.41.34.463567 AMdirect116814685.8––
242910-NOV-07 03.49.25.526321 AMdirect117950125154–
243002-OCT-07 06.18.36.663332 AMdirect101829669.9159–
243114-SEP-06 07.03.04.763452 AMdirect10215610.6163–
243701-SEP-06 08.59.15.826132 AMdirect103413550163–
243801-SEP-07 09.53.26.934626 AMdirect10405451154–
243931-AUG-07 10.19.37.811132 AMdirect105122150.1159–
244101-AUG-08 11.22.48.734526 AMdirect10652075.2160–
244227-JUL-06 12.22.59.662632 PMdirect107952471.9154–
244327-JUL-06 01.34.16.562632 PMdirect10803646154–
244427-JUL-07 02.22.27.462632 PMdirect109177727.2155–
244527-JUL-06 03.34.38.362632 PMdirect14485537.8158–
244818-JUN-07 04.41.49.262632 PMdirect14551388158–
244913-JUN-07 05.49.07.162632 PMdirect146686155–
245011-APR-07 06.18.10.362632 PMdirect14731636159–
245117-DEC-07 05.03.52.562632 PMdirect148710474.6154–
245206-OCT-07 08.59.43.462632 PMdirect149512589159–
245304-OCT-07 09.53.34.362632 PMdirect1160129153–
245607-NOV-06 07.53.25.989889 PMdirect11703878.4163–
245731-OCT-07 11.22.16.162632 PMdirect118521586.2159–
oe.order_items
Contains information related to each item within a specific order. There is one row for each item within each order. For example, if a specific order has five items, then those five items will be represented by and captured within five individual rows.
order_idline_item_idproduct_idunit_pricequantity
2354131064861
23542311496.843
2354331237947
2354431294147
2354531392148
2354631431653
2354731501758
2354831633061
2354931653764
23541031675168
2354113170145.270
2354123176113.372
23541331826177
23551228946200
23552230857185
23553231186.9188
23554232219188
23555232317190
2355623261.1192
2355723301.1197
23558233925199
235592359226.6204
235612264199.138
235622274148.534
2356322939840
2356422997244
2356523085847
2356623119551
2356723162255
2356823231855
2357122113.3140
23572224546226
235732252788.726
235742257371.829
2357522629529
2357622687532
235772276236.538
2357822894841
235811781226.69
2358217821254
235831797316.812
2358418035513
2358518085514
235912337270.61
2359223592491
2359323709117
235942373617
2359523779617
2359623805.517
2359723819717
2360120582329
2360220937.742
23611228946180
23612229976180
23613230853182
23614231186.9185
23615231622187
2361623261.1194
2361723343.3198
236182359248208
23619236576209
23621228948200
23622229976160
23623231193164
23624231622168
2362523261.1173
2362623343.3177
23627233925179
236282359248189
236312264199.19
2363222721297
2363322997425
2363423085726
23635231186.929
2363623192431
2363723231834
2363823261.137
2363923343.342
236411910146
236421948470.820
2365122894892
2365222939928
236532302133.129
2365423085629
2365523119529
2365623162234
2365723192438
2365823221943
2365923261.144
23651023359745
23651123392550
23651223407254
236612359226.68
23662237367
236632382804.110
236642394116.611
23665239512012
23666240041816
236672406195.820
236682409194.722
236692415339.924
23661024196924
2367122894899
23672230214732
2367323085439
2367423222245
2367523261.148
2367623301.152
23677233591.354
2367823502341.954
23681310648150
2368231104260
2368331173862
2368431238170
23685312749670
2368631294272
2368731431675
2368831554575
236913150183
236923155431
236933163325
2369431653410
236953170145.224
236963176113.324
2369731872.224
2369831932.228
23699320412334
237011910149
2371122741576
237122293968
2371322997315
2371423162121
2371523231724
2371623343.326
2371723392529
2371823502341.932
237213106486
237223108742
237233110427
2372431238110
23725312749613
2372631341717
2372731431521
2372831633030
2372931675432
2372103170145.236
237311820498
237321825241
23741242215010
237422423786
2374324497815
2374424677921
23751310642140
2375231127184
2375331173885
237543127488.486
2375531334588
2375631341790
2375731431593
2375831501793
2375931554598
23751031633099
237511316536103
2375123171132107
2375133176120109
2376122706014
237622276236.54
2376322939913
2376422997317
237652302133.121
2376623119525
2376723162127
2376823192532
2376923261.133
23761023343.336
23771228942130
237722302147119
23773231195121
23774231925131
2377523261.1132
2377623301.1136
237812403113.320
237822412952
237832414438.97
2378424172711
2378524237911
237862424217.815
2378724574.425
237882459624.825
2379131064292
2379231149814
237933127488.423
2379431392134
2379531401935
2380131064226
2380231087518
2380331173823
238043127488.424
2380531334628
2380631402030
2380731431531
2380831501733
2380931554533
23801031633236
23801131675237
2380123176113.340
23801331872.240
23811311738110
2381231247744
2381331334444
2381431392045
2381531431548
2381631633555
238173176113.362
2381831834763
23821310642160
2382231104364
23823311410065
2382431173566
2382531237971
23826312749671
2382731294276
2382831392179
2382931431582
23821031632989
23821131653792
238312409194.737
2383224185645
23833242214646
23834243017450
238352439115.554
2383624574.462
2383724627563
2384122894395
2384222997148
2384323162158
2384423222259
2384523301.161
23846235924977
23851228943200
238522302133.187
23853231186.996
2385423192597
23855233591.3106
2385623502341.9109
2386123301.17
2386223343.35
2386323407114
2386423657727
2386523709028
2386623757332
238672378271.733
238682394116.636
2387122113.352
238722243332.220
23873224546222
238742252788.727
238752253354.232
2387622687542
23881228943150
2388222939490
2388323085696
2388423301.1105
2388523502341.9112
23891310643180
2389231127318
2389331238021
2389431294622
2389531431530
2389631554633
2389731653443
2389831675247
239011910144
239021912142
239031948470.816
2391117871015
239121791262.93
2391317973487
239141799961.410
2391518085515
2391618205218
2391718221433.323
2392131064363
2392231127357
2392331173858
2392431247763
2392531334566
2392631392168
2392731501872
2392831554977
2392931654081
2393130511210
2393230602952
23933306410175
2393430693858
239353077260.78
2393630827810
23937308621113
239383087108.914
23939309127819
23931030993.319
239311310869.330
2394131174190
2394231237736
2394331248239
2394431294641
2394531334645
2394631341845
2394731401948
2394831554961
2394931675268
2395122113.3110
239522243332.227
239532252788.730
239542255690.834
239552264199.134
2395622687137
2395722706441
23961310644150
2396231087675
2396331104479
23964311410083
2396531401993
2396631501793
2396731554798
23968316329100
239712976522
2397229861208
23973299988016
2397430001696.216
239812471482.95
239822537193.623
239832594927
23991228944120
2399222939412
2399322997615
23994230214917
2399523085617
23996231186.920
2399723162224
2399823261.127
2399923301.128
239910233510033
2399112359226.638
240012976524
240022982411
2400329861234
24004299988016
2400530032866.619
240112492414
240122496268.43
240212536758
240312522445
240412721856
240422808037
2405126381379
240612721855
2406227253.34
2406327612619
2406427826231
240712721855
2407227528618
2407327612621
240812751613
240822761261
2408327831010
24091281068
2410129764610
241022982405
2410329861206
241042995688
2410530032866.615
2410630511221
241113082812
2411230862082
2411330972.26
2411430993.37
241153101738
2411631064511
2411731127217
2411831237517
2411931248417
2411103127488.418
24111131334323
24111231431524
24121310646170
2412231149868
24123312371.568
24124312749272
2412531341875
2412631392079
2412731431680
2412831633092
2412931675494
24131310877200
2413231127540
2413331173544
24134312749244
2413531294645
2413631554762
2413731633066
2414132081.18
241423216307
241433220419
2414432343911
241453246212.318
241463253206.823
2414732605024
241512751625
2416128704.410
2416228783401
2417128704.49
2417229765137
2418130827515
24182309018712
2418330972.213
2418431104520
2418531402031
2418631501737
24191310646150
2419231149945
24193312371.548
2419431294357
2419531334561
2419631501769
2419731554772
2419831653576
2419931675481
24201310646110
2420231104611
24203311410115
2420431237920
24205312749622
2420631334829
2420731401934
2420831431539
2420931633045
242010317113247
24211310646160
24212310878160
24213311272164
24214311741165
24215312380168
24216312943172
24217314315176
24218315017176
24219315543185
2422131064618
242223117415
24223312371.55
2422431274969
2422531334611
2422631501725
2422731554329
2422831633035
2422931675439
242313220398
242323224323
242333245214.513
242343246212.314
2423532512616
2423632587821
2423732906533
24241335069311
2424233545419
24243335911112
242513501492.83
24252351192
2425335151.14
2426131932.26
2426232163011
2426332343418
242643248212.326
2426532522529
24271243017312
2427224391211
2427324574.46
242742464666
242752470766
242762496268.419
2427725224022
242813106427
242823108761
2428331141015
242843117416
242853123808
24286312749812
2428731334812
2428831431613
2428931501716
2428103170145.224
24281131738628
24291310642200
2429231087640
2429331104543
2429431237946
24295312749749
2429631334652
2429731392154
2429831501755
2429931633063
24291031653667
2430133506936
243023353454.35
24303335911110
2430433629410
243053501492.843
2431130972.23
243123106481
2431331141013
243143117417
2431531274989
2431631294411
243212976493
243222982432
2432329861225
24324299988011
243311910136
2434122113.381
243422236949.384
24343224546286
243442252788.787
243452254408.192
243462257371.894
24347226875104
2435122894835
243522299754
24353231186.98
2435423162110
2435523231812
2435623343.314
2435723392519
2435823502341.924
2435923657533
2436132081.18
243623209132
243633216303
243643224326
243653245214.516
2436632502718
2436732563618
2436832906324
243712423838
243722430157.34
2437324574.417
2437424627619
2437524646421
243762496268.435
243812995693
24382300017483
243911797316.89
243921806454
243931820549
2439418221433.313
2440122894819
244022293982
2440323021502
24404231186.97
2440523222310
2440623301.113
2440723343.315
244082337270.619
2440923392523
24401023502341.924
2440112359226.628
244112536809
244122537193.67
24421240212726
244222410350.921
2442324186023
24424242214425
24425243017328
244262439115.530
244272459624.840
2442824678044
244313106443
2443231141012
244333124826
2443431392012
2443531431517
2443631501817
2443731554321
2443831653631
24441311736110
244423127488.488
2444331334390
2444431392193
2444531401995
2444631431597
24447315017100
24448315543104
24449316537112
244410317237112
244411318263115
244512270665
244522278493
2445322939711
2445422997214
2445523119524
2445623192527
2445723261.128
2446122894847
2446223261.134
2446323301.136
244642337270.637
2446523502341.939
244712264199.129
24472226629723
24473227212124
2447422785025
2447522939734
2447622997635
244772302133.137
2447823085440
2447923119344
244813106443
244823114990
2448331334211
2448431341714
2448531392015
2448631431616
244912522432
2450131911.14
2450231932.23
245033197445
2450432162911
2450532204114
2450632243216
245111910139
245121948470.822
24521311738140
2452231392010
2452331431512
2452431501713
2452531554413
2452631653418
245273170145.220
2452831723720
2452931738023
245312492433
24541228943120
245422293990
245432299713
2454423085512
2454523162113
2454623231816
2454723343.318
245512471482.93
245522496268.432
2455325367554
245612522405
245622537193.619
2457131087236
2457231237914
245733127488.417
2457431501727
2457531554432
245763170145.242
2457731723645
24581311738140
24582312379112
245833127488.4114
24584313417115
24585314315129
24586316332142
oe.product_information
Contains information related to each product. There is one row per product.
product_idproduct_nameproduct_descriptioncategory_idweight_classwarranty_periodsupplier_idproduct_statuslist_pricemin_pricecatalog_url
1797Inkjet C/8/HQInkjet printer, color, 8 pages per minute, high resolution (photo quality). Memory: 16MB. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A4, US Letter, envelopes. Interface: Centronics parallel, IEEE 1284 compliant.1232102094orderable349288http://www.supp-102094.com/cat/hw/p1797.html
2459LaserPro 1200/8/BWProfessional black and white laserprinter, resolution 1200 dpi, 8 pages per second. Dimensions (HxWxD): 22.37 x 19.86 x 21.92 inch. Software: Enhanced driver support for SPNIX v4.0; MS-DOS Built-in printer drivers: ZoomSmart scaling technology, billboard, handout, mirror, watermark, print preview, quick sets, emulate laserprinter margins.1253102099under development699568http://www.supp-102099.com/cat/hw/p2459.html
3127LaserPro 600/6/BWStandard black and white laserprinter, resolution 600 dpi, 6 pages per second. Interface: Centronics parallel, IEEE 1284 compliant. Memory: 8MB 96KB receiver buffer. MS-DOS ToolBox utilities for SPNIX AutoCAM v.17 compatible driver.1243102087orderable498444http://www.supp-102087.com/cat/hw/p3127.html
2254HD 10GB /I10GB capacity hard disk drive (internal). These drives are intended for use in today’s demanding, data-critical enterprise environments and are ideal for use in RAID applications. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.1322102071obsolete453371http://www.supp-102071.com/cat/hw/p2254.html
3353HD 10GB /R10GB Removable hard disk drive for 10GB Removable HD drive. Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 160MB/s.1313102071obsolete489413http://www.supp-102071.com/cat/hw/p3353.html
3069HD 10GB /S10GB hard disk drive for Standard Mount. Backward compatible with Supra5 systems, users are free to deploy and re-deploy these drives to quickly deliver increased storage capacity. Supra drives eliminate the risk of firmware incompatibility.1312102051obsolete436350http://www.supp-102051.com/cat/hw/p3069.html
2253HD 10GB @5400 /SE10GB capacity hard disk drive (external) SCSI interface, 5400 RPM. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system. Supra drives eliminate the risk of firmware incompatibility.1323102069obsolete399322http://www.supp-102069.com/cat/hw/p2253.html
3354HD 12GB /I12GB capacity harddisk drive (internal). Supra drives eliminate the risk of firmware incompatibility. Backward compatibility: You can mix or match Supra2 and Supra3 devices for optimized solutions and future growth.1322102066orderable543478http://www.supp-102066.com/cat/hw/p3354.html
3072HD 12GB /N12GB hard disk drive for Narrow Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.1313102061orderable567507http://www.supp-102061.com/cat/hw/p3072.html
3334HD 12GB /R12GB Removable hard disk drive. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity. Supra7 Universal disk drives are the second generation of high performance hot plug drives sharing compatibility across corporate servers and external storage enclosures.1323102090orderable612512http://www.supp-102090.com/cat/hw/p3334.html
3071HD 12GB /S12GB hard disk drive for Standard Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.1313102071orderable633553http://www.supp-102071.com/cat/hw/p3071.html
2255HD 12GB @7200 /SE12GB capacity hard disk drive (external) SCSI, 7200 RPM. These drives are intended for use in today’s demanding, data-critical enterprise environments and can be used in RAID applications. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.1322102057orderable775628http://www.supp-102057.com/cat/hw/p2255.html
1743HD 18.2GB @10000 /EExternal hard drive disk – 18.2 GB, rated up to 10,000 RPM. These drives are intended for use in today’s demanding, data-critical enterprise environments and are ideal for use in RAID applications.1333102078planned800661http://www.supp-102078.com/cat/hw/p1743.html
2382HD 18.2GB@10000 /I18.2 GB SCSI hard disk @ 10000 RPM (internal). Supra7 Universal disk drives provide an unequaled level of investment protection and simplification for customers by enabling drive compatibility across many enterprise platforms.1333102050under development850731http://www.supp-102050.com/cat/hw/p2382.html
3399HD 18GB /SE18GB SCSI external hard disk drive. Supra5 Universal hard disk drives provide the ability to hot plug between various servers, RAID arrays, and external storage shelves.1332102083under development815706http://www.supp-999999.com/cat/hw/p3333.html
3073HD 6GB /I6GB capacity hard disk drive (internal). Supra drives eliminate the risk of firmware incompatibility.1325102072obsolete224197http://www.supp-102083.com/cat/hw/p3073.html
1768HD 8.2GB @5400Hard drive disk – 8.2 GB, rated up to 5,400 RPM. Supra drives eliminate the risk of firmware incompatibility. Standard serial RS-232 interface.1322102093orderable345306http://www.supp-102093.com/cat/hw/p1768.html
2410HD 8.4GB @54008.4 GB hard disk @ 5400 RPM. Reduced cost of ownership: Drives can be utilized across enterprise platforms. This hot pluggable hard disk drive is required to meet your rigorous standards for reliability and performance.1323102061orderable357319http://www.supp-102061.com/cat/hw/p2410.html
2257HD 8GB /I8GB capacity hard disk drive (internal). Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Backward compatibility: You can mix Supra2 and Supra3 devices for optimized solutions and future growth.1313102061orderable399338http://www.supp-102061.com/cat/hw/p2257.html
3400HD 8GB /SE8GB capacity SCSI hard disk drive (external). Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 255MB/s.1323102063orderable389337http://www.supp-102063.com/cat/hw/p3400.html
3355HD 8GB /SI8GB SCSI hard disk drive, internal. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity. 1312102050orderable – – http://www.supp-102050.com/cat/hw/p3355.html
1772HD 9.1GB @10000Hard disk drive – 9.1 GB, rated up to 10,000 RPM. These drives are intended for use in data-critical enterprise environments. Ease of doing business: you can easily select the drives you need regardless of the application in which they will be deployed.1335102070orderable456393http://www.supp-102070.com/cat/hw/p1772.html
2243Monitor 17/HR/FMonitor 17 inch (16 viewable) high resolution, flat screen. High density photon gun with Enhanced Elliptical Correction System for more consistent, accurate focus across the screen, even in the corners.114-6102060orderable350302http://www.supp-102060.com/cat/hw/p2243.html
3057Monitor 17/SDCRT Monitor 17 inch (16 viewable) short depth. Delivers outstanding image clarity and precision. Gives professional color, technical engineering, and visualization/animation users the color fidelity they demand, plus a large desktop for enhanced productivity.114-6102055orderable369320http://www.supp-102055.com/cat/hw/p3057.html
3061Monitor 19/SDCRT Monitor 19 inch (18 viewable) short depth. High-contrast black screen coating: produces superior contrast and grayscale performance. The newly designed, amplified professional speakers with dynamic bass response bring all of your multimedia audio experiences to life with crisp, true-to-life sound and rich, deep bass tones. Plus, color-coded cables, simple plug-and-play setup and digital on-screen controls mean you are ready to set your sights on outrageous multimedia and the incredible Internet in just minutes.115-9102094orderable499437http://www.supp-102094.com/cat/hw/p3061.html
2245Monitor 19/SD/MMonitor 19 (18 Viewable) short depth, Monochrome. Outstanding image performance in a compact design. A simple, on-screen dislay menu helps you easily adjust screen dimensions, colors and image attributes. Just plug your monitor into your PC and you are ready to go.115-9102053orderable512420http://www.supp-102053.com/cat/hw/p2245.html
3065Monitor 21/DCRT Monitor 21 inch (20 viewable). Digital OptiScan technology: supports resolutions up to 1600 x 1200 at 75Hz. Dimensions (HxWxD): 8.3 x 18.5 x 15 inch. The detachable or attachable monitor-powered Platinum Series speakers offer crisp sound and the convenience of a digital audio player jack. Just plug in your digital audio player and listen to tunes without powering up your PC.1151102051orderable999875http://www.supp-102051.com/cat/hw/p3065.html
3331Monitor 21/HR21 inch monitor (20 inch viewable) high resolution. This monitor is ideal for business, desktop publishing, and graphics-intensive applications. Enjoy the productivity that a large monitor can bring via more workspace for running applications.1151102083orderable879785http://www.supp-102083.com/cat/hw/p3331.html
2252Monitor 21/HR/MMonitor 21 inch (20 viewable) high resolution, monochrome. Unit size: 35.6 x 29.6 x 33.3 cm (14.6 kg) Package: 40.53 x 31.24 x 35.39 cm (16.5 kg). Horizontal frequency 31.5 – 54 kHz, Vertical frequency 50 – 120 Hz. Universal power supply 90 – 132 V, 50 – 60 Hz.115-5102079obsolete889717http://www.supp-102079.com/cat/hw/p2252.html
3064Monitor 21/SDMonitor 21 inch (20 viewable) short depth. Features include a 0.25-0.28 Aperture Grille Pitch, resolution support up to 1920 x 1200 at 76Hz, on-screen displays, and a conductive anti-reflective film coating.115-5102096planned1023909http://www.supp-102096.com/cat/hw/p3064.html
3155Monitor Hinge – HDMonitor Hinge, heavy duty, maximum monitor weight 30 kg11410102092orderable4942http://www.supp-102092.com/cat/hw/p3155.html
3234Monitor Hinge – STDStandard Monitor Hinge, maximum monitor weight 10 kg11310102072orderable3934http://www.supp-102072.com/cat/hw/p3234.html
3350Plasma Monitor 10/LE/VGA10 inch low energy plasma monitor, VGA resolution1131102068orderable740630http://www.supp-102068.com/cat/hw/p3350.html
2236Plasma Monitor 10/TFT/XGA10 inch TFT XGA flatscreen monitor for laptop computers1131102090under development964863http://www.supp-102090.com/cat/hw/p2236.html
3054Plasma Monitor 10/XGA10 inch standard plasma monitor, XGA resolution. This virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.1131102060orderable600519http://www.supp-102060.com/cat/hw/p3054.html
1782Compact 400/DQ400 characters per second high-speed draft printer. Dimensions (HxWxD): 17.34 x 24.26 x 26.32 inch. Interface: RS-232 serial (9-pin), no expansion slots. Paper size: A4, US Letter.124-5102088obsolete125108http://www.supp-102088.com/cat/hw/p1782.html
2430Compact 400/LQ400 characters per second high-speed letter-quality printer. Dimensions (HxWxD): 12.37 x 27.96 x 23.92 inch. Interface: RS-232 serial (25-pin), 3 expansion slots. Paper size: A2, A3, A4.1242102087orderable175143http://www.supp-102087.com/cat/hw/p2430.html
1792Industrial 600/DQWide carriage color capability 600 characters per second high-speed draft printer. Dimensions (HxWxD): 22.31 x 25.73 x 20.12 inch. Paper size: 3×5 inch to 11×17 inch full bleed wide format.1245102088orderable225180http://www.supp-102088.com/cat/hw/p1792.html
1791Industrial 700/HD700 characters per second dot-matrix printer with harder body and dust protection for industrial uses. Interface: Centronics parallel, IEEE 1284 compliant. Paper size: 3×5 inch to 11×17 inch full bleed wide format. Memory: 4MB. Dimensions (HxWxD): 9.3 x 16.5 x 13 inch.1255102086orderable275239http://www.supp-102086.com/cat/hw/p1791.html
2302Inkjet B/6Inkjet Printer, black and white, 6 pages per minute, resolution 600×300 dpi. Interface: Centronics parallel, IEEE 1284 compliant. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A3, A4, US legal. No expansion slots.1232102096orderable150121http://www.supp-102096.com/cat/hw/p2302.html
2453Inkjet C/4Inkjet Printer, color (with two separate ink cartridges), 6 pages per minute black and white, 4 pages per minute color, resolution 600×300 dpi. Interface: Biodirectional IEEE 1284 compliant parallel interface and RS-232 serial (9-pin) interface 2 open EIO expansion slots. Memory: 8MB 96KB receiver buffer.1232102090orderable195174http://www.supp-102090.com/cat/hw/p2453.html
2810Inkvisible PensRollerball pen is equipped with a smooth precision tip. See-through rubber grip allows for a visible ink supply and comfortable writing. 4-pack with 1 each, black, blue, red, green.3210103095orderable64http://www.supp-103095.com/cat/off/p2810.html
2870Pencil – MechErgonomically designed mechanical pencil for improved writing comfort. Refillable erasers and leads. Available in three lead sizes: .5mm (fine); .7mm (medium); and .9mm (thick).3212103097orderable54http://www.supp-103097.com/cat/off/p2870.html
1781CDW 20/48/ECD Writer, read 48x, write 20x172-9102060orderable233206http://www.supp-102060.com/cat/hw/p1781.html
2264CDW 20/48/ICD-ROM drive: read 20x, write 48x (internal)172-9102060orderable223181http://www.supp-102060.com/cat/hw/p2264.html
2260DFD 1.44/3.5Dual Floppy Drive – 1.44 MB – 3.5172-6102062orderable6754http://www.supp-102062.com/cat/hw/p2260.html
2266DVD 12xDVD-ROM drive: speed 12x1731102099orderable333270http://www.supp-102099.com/cat/hw/p2266.html
3077DVD 8xDVD – ROM drive, 8x speed. Will probably become obsolete pretty soon…1731102099orderable274237http://www.supp-102099.com/cat/hw/p3077.html
2259FD 1.44/3.5Floppy Drive – 1.44 MB High Density capacity – 3.5 inch chassis171-9102086orderable3932http://www.supp-102086.com/cat/hw/p2259.html
2261FD 1.44/3.5/EFloppy disk drive – 1.44 MB (high density) capacity – 3.5 inch (external)172-9102086orderable4237http://www.supp-102086.com/cat/hw/p2261.html
3082Modem – 56/90/EModem – 56kb per second, v.90 PCI Global compliant. External; for power supply 110V.1711102068orderable8172http://www.supp-102068.com/cat/hw/p3082.html
2270Modem – 56/90/IModem – 56kb per second, v.90 PCI Global compliant. Internal, for standard chassis (3.5 inch).1711102068orderable6656http://www.supp-102068.com/cat/hw/p2270.html
2268Modem – 56/H/EStandard Hayes compatible modem – 56kb per second, external. Power supply: 220V.1711102068obsolete7767http://www.supp-102068.com/cat/hw/p2268.html
3083Modem – 56/H/IStandard Hayes modem – 56kb per second, internal, for standard 3.5 inch chassis.1711102068orderable6756http://www.supp-102068.com/cat/hw/p3083.html
2374Modem – C/100DOCSIS/EURODOCSIS 1.0/1.1-compliant external cable modem172-5102064orderable6554http://www.supp-102064.com/cat/hw/p2374.html
1740TD 12GB/DATTape drive – 12 gigabyte capacity, DAT format.172-5102075orderable134111http://www.supp-102075.com/cat/hw/p1740.html
2409TD 7GB/8Tape drive, 7GB capacity, 8mm cartridge tape.172-5102054orderable210177http://www.supp-102054.com/cat/hw/p2409.html
2262ZIP 100ZIP Drive, 100 MB capacity (external) plus cable for parallel port connection172-5102054orderable9881http://www.supp-102054.com/cat/hw/p2262.html
2522Battery – ELExtended life battery, for laptop computers192-3102078orderable4439http://www.supp-102078.com/cat/hw/p2522.html
2278Battery – NiHMRechargeable NiHM battery for laptop computers191-3102078orderable5548http://www.supp-102078.com/cat/hw/p2278.html
2418Battery Backup (DA-130)Single-battery charger with LED indicators191-3102074orderable6152http://www.supp-102074.com/cat/hw/p2418.html
2419Battery Backup (DA-290)Two-battery charger with LED indicators191-3102074orderable7260http://www.supp-102074.com/cat/hw/p2419.html
3097Cable Connector – 32RCable Connector – 32 pin ribbon1910102055orderable32http://www.supp-102055.com/cat/hw/p3097.html
3099Cable HarnessCable harness to organize and bundle computer wiring1910102055orderable43http://www.supp-102055.com/cat/hw/p3099.html
2380Cable PR/15/P15 foot parallel printer cable192-1102055orderable65http://www.supp-102055.com/cat/hw/p2380.html
2408Cable PR/P/6Standard Centronics 6ft printer cable, parallel port191-1102055orderable43http://www.supp-102055.com/cat/hw/p2408.html
2457Cable PR/S/6Standard RS232 serial printer cable, 6 feet191-1102055orderable54http://www.supp-102055.com/cat/hw/p2457.html
2373Cable RS232 10/AF10 ft RS232 cable with F/F and 9F/25F adapters1921102055orderable64http://www.supp-102055.com/cat/hw/p2373.html
1734Cable RS232 10/AM10 ft RS232 cable with M/M and 9M/25M adapters1921102055orderable65http://www.supp-102055.com/cat/hw/p1734.html
1737Cable SCSI 10/FW/ADS10ft SCSI2 F/W Adapt to DSxx0 Cable192-2102095orderable86http://www.supp-102095.com/cat/hw/p1737.html
1745Cable SCSI 20/WD->D20ft SCSI2 Wide Disk Store to Disk Store Cable192-2102095orderable97http://www.supp-102095.com/cat/hw/p1745.html
2982Drive Mount – ADrive Mount assembly kit192-1102057orderable4435http://www.supp-102057.com/cat/hw/p2982.html
3277Drive Mount – A/TDrive Mount assembly kit for tower PC1921102057orderable3629http://www.supp-102057.com/cat/hw/p3277.html
2976Drive Mount – DDrive Mount for desktop PC1921102057orderable5244http://www.supp-102057.com/cat/hw/p2976.html
3204Envoy DSEnvoy Docking Station1932102060orderable126107http://www.supp-102060.com/cat/hw/p3204.html
2638Envoy DS/EEnhanced Envoy Docking Station1932102060orderable137111http://www.supp-102060.com/cat/hw/p2638.html
3020Envoy ICEnvoy Internet Computer, Plug&Play1941102060orderable449366http://www.supp-102060.com/cat/hw/p3020.html
1948Envoy IC/58Internet computer with built-in 58K modem194-5102060orderable498428http://www.supp-102060.com/cat/hw/p1948.html
3003Laptop 128/12/56/v90/110Envoy Laptop, 128MB memory, 12GB hard disk, v90 modem, 110V power supply.194-5102060orderable32192606http://www.supp-102060.com/cat/hw/p3003.html
2999Laptop 16/8/110Envoy Laptop, 16MB memory, 8GB hard disk, 110V power supply (US only).193-5102060obsolete999800http://www.supp-102060.com/cat/hw/p2999.html
3000Laptop 32/10/56Envoy Laptop, 32MB memory, 10GB hard disk, 56K Modem, universal power supply (switchable).194-5102060orderable17491542http://www.supp-102060.com/cat/hw/p3000.html
3001Laptop 48/10/56/110Envoy Laptop, 48MB memory, 10GB hard disk, 56K modem, 110V power supply.194-5102060obsolete25562073http://www.supp-102060.com/cat/hw/p3001.html
3004Laptop 64/10/56/220Envoy Laptop, 64MB memory, 10GB hard disk, 56K modem, 220V power supply.194-5102060orderable27682275http://www.supp-102060.com/cat/hw/p3004.html
3391PS 110/220Power Supply – switchable, 110V/220V192-5102062orderable8575http://www.supp-102062.com/cat/hw/p3391.html
3124PS 110V /TPower supply for tower PC, 110V1921102062orderable8470http://www.supp-102062.com/cat/hw/p3124.html
1738PS 110V /US110 V Power Supply – US compatible1921102062orderable8670http://www.supp-102062.com/cat/hw/p1738.html
2377PS 110V HS/US110 V hot swappable power supply – US compatible1921102062orderable9782http://www.supp-102062.com/cat/hw/p2377.html
2299PS 12V /PPower Supply – 12v portable1921102062orderable7664http://www.supp-102062.com/cat/hw/p2299.html
2414HD 9.1GB @10000 /I9.1 GB SCSI hard disk @ 10000 RPM (internal). Supra7 disk drives are available in 10,000 RPM spindle speeds and capacities of 18GB and 9.1 GB. SCSI and RS-232 interfaces.1335102098orderable454399http://www.supp-102098.com/cat/hw/p2414.html
2415HD 9.1GB @72009.1 GB hard disk @ 7200 RPM. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.1335102063orderable359309http://www.supp-102063.com/cat/hw/p2415.html
239532MB Cache /M32MB Mirrored cache memory (100-MHz Registered SDRAM)141-6102093orderable123109http://www.supp-102093.com/cat/hw/p2395.html
175532MB Cache /NM32MB Non-Mirrored cache memory141-6102076orderable12199http://www.supp-102076.com/cat/hw/p1755.html
240664MB Cache /M64MB Mirrored cache memory141-6102059orderable223178http://www.supp-102059.com/cat/hw/p2406.html
240464MB Cache /NM64 MB Non-mirrored cache memory. FPM memory chips are implemented on 5 volt SIMMs, but are also available on 3.3 volt DIMMs.141-6102087orderable221180http://www.supp-102087.com/cat/hw/p2404.html
17708MB Cache /NM8MB Non-Mirrored Cache Memory (100-MHz Registered SDRAM)141-6102050orderable – 73http://www.supp-102050.com/cat/hw/p1770.html
24128MB EDO Memory8 MB 8×32 EDO SIM memory. Extended Data Out memory differs from FPM in a small, but significant design change. Unlike FPM, the data output drivers for EDO remain on when the memory controller removes the column address to begin the next cycle. Therefore, a new data cycle can begin before the previous cycle has completed. EDO is available on SIMMs and DIMMs, in 3.3 and 5 volt varieties.141-6102058obsolete9883http://www.supp-102058.com/cat/hw/p2412.html
2378DIMM – 128 MB128 MB DIMM memory. The main reason for the change from SIMMs to DIMMs is to support the higher bus widths of 64-bit processors. DIMMs are 64- or 72-bits wide; SIMMs are only 32- or 36-bits wide (with parity).141-6102050orderable305247http://www.supp-102050.com/cat/hw/p2378.html
3087DIMM – 16 MBCitrus OLX DIMM – 16 MB capacity.141-6102081obsolete12499http://www.supp-102081.com/cat/hw/p3087.html
2384DIMM – 1GBMemory DIMM: RAM – 1 GB capacity.141-6102074under development599479http://www.supp-102074.com/cat/hw/p2384.html
1749DIMM – 256MBMemory DIMM: RAM 256 MB. (100-MHz Registered SDRAM)141-6102053orderable337300http://www.supp-102053.com/cat/hw/p1749.html
1750DIMM – 2GBMemory DIMM: RAM, 2 GB capacity.141-6102052orderable699560http://www.supp-102052.com/cat/hw/p1750.html
2394DIMM – 32MB32 MB DIMM Memory upgrade141-6102054orderable128106http://www.supp-102054.com/cat/hw/p2394.html
2400DIMM – 512 MB512 MB DIMM memory. Improved memory upgrade granularity: Fewer DIMMs are required to upgrade a system than it would require if using SIMMs in the same system. Increased maximum memory ceilings: Given the same number of memory slots, the maximum memory of a system using DIMMs is more than one using SIMMs. DIMMs have separate contacts on each side of the board, which provide two times the data rate as one SIMM.1411102098under development448380http://www.supp-102098.com/cat/hw/p2400.html
1763DIMM – 64MBMemory DIMM: RAM, 64MB (100-MHz Unregistered ECC SDRAM)1411102069orderable247202http://www.supp-102069.com/cat/hw/p1763.html
2396EDO – 32MBMemory EDO SIM: RAM, 32 MB (100-MHz Unregistered ECC SDRAM). Like FPM, EDO is available on SIMMs and DIMMs, in 3.3 and 5 volt varieties If EDO memory is installed in a computer that was not designed to support it, the memory may not work.141-6102051orderable179149http://www.supp-102051.com/cat/hw/p2396.html
2272RAM – 16 MBMemory SIMM: RAM – 16 MB capacity.1411102074obsolete135110http://www.supp-102074.com/cat/hw/p2272.html
2274RAM – 32 MBMemory SIMM: RAM – 32 MB capacity.1411102064orderable161135http://www.supp-102064.com/cat/hw/p2274.html
3090RAM – 48 MBRandom Access Memory, SIMM – 48 MB capacity.1411102084orderable193170http://www.supp-102084.com/cat/hw/p3090.html
1739SDRAM – 128 MBSDRAM memory, 128 MB capacity. SDRAM can access data at speeds up to 100 MHz, which is up to four times as fast as standard DRAMs. The advantages of SDRAM can be fully realized, however, only by computers designed to support SDRAM. SDRAM is available on 5 and 3.3 volt DIMMs.141-9102077orderable299248http://www.supp-102077.com/cat/hw/p1739.html
3359SDRAM – 16 MBSDRAM memory upgrade module, 16 MB. Synchronous Dynamic Random Access Memory was introduced after EDO. Its architecture and operation are based on those of the standard DRAM, but SDRAM provides a revolutionary change to main memory that further reduces data retrieval times. SDRAM is synchronized to the system clock that controls the CPU. This means that the system clock controlling the functions of the microprocessor also controls the SDRAM functions. This enables the memory controller to know on which clock cycle a data request will be ready, and therefore eliminates timing delays.141-9102059orderable11199http://www.supp-102059.com/cat/hw/p3359.html
3088SDRAM – 32 MBSDRAM module with ECC – 32 MB capacity. SDRAM has multiple memory banks that can work simultaneously. Switching between banks allows for a continuous data flow.141-9102057orderable258220http://www.supp-102057.com/cat/hw/p3088.html
2276SDRAM – 48 MBMemory SIMM: RAM – 48 MB. SDRAM can operate in burst mode. In burst mode, when a single data address is accessed, an entire block of data is retrieved rather than just the one piece. The assumption is that the next piece of data that will be requested will be sequential to the previous. Since this is usually the case, data is held readily available.141-9102058orderable269215http://www.supp-102058.com/cat/hw/p2276.html
3086VRAM – 16 MBCitrus Video RAM module – 16 MB capacity. VRAM is used by the video system in a computer to store video information and is reserved exclusively for video operations. It was developed to provide continuous streams of serial data for refreshing video screens.141-6102056orderable211186http://www.supp-102056.com/cat/hw/p3086.html
3091VRAM – 64 MBCitrus Video RAM memory module – 64 MB capacity. Physically, VRAM looks just like DRAM with added hardware called a shift register. The special feature of VRAM is that it can transfer one entire row of data (up to 256 bits) into this shift register in a single clock cycle. This ability significantly reduces retrieval time, since the number of fetches is reduced from a possible 256 to a single fetch. The main benefit of having a shift register available for data dumps is that it frees the CPU to refresh the screen rather than retrieve data, thereby doubling the data bandwidth. For this reason, VRAM is often referred to as being dual-ported. However, the shift register will only be used when the VRAM chip is given special instructions to do so. The command to use the shift register is built into the graphics controller.141-6102098orderable279243http://www.supp-102098.com/cat/hw/p3091.html
1787CPU D300Dual CPU @ 300Mhz. For light personal processing only, or file servers with less than 5 concurrent users. This product will probably become obsolete soon.1513102097orderable10190http://www.supp-102097.com/cat/hw/p1787.html
2439CPU D400Dual CPU @ 400Mhz. Good price/performance ratio; for mid-size LAN file servers (up to 100 concurrent users).1513102092orderable123105http://www.supp-102092.com/cat/hw/p2439.html
1788CPU D600Dual CPU @ 600Mhz. State of the art, high clock speed; for heavy load WAN servers (up to 200 concurrent users).1515102067orderable178149http://www.supp-102067.com/cat/hw/p1788.html
2375GP 1024×768Graphics Processor, resolution 1024 X 768 pixels. Outstanding price/performance for 2D and 3D applications under SPNIX v3.3 and v4.0. Double your viewing power by running two monitors from this single card. Two 17 inch monitors have more screen area than one 21 inch monitor. Excellent option for users that multi-task frequently or access data from multiple sources often.151-9102063orderable7869http://www.supp-102063.com/cat/hw/p2375.html
2411GP 1280×1024Graphics Processor, resolution 1280 X 1024 pixels. High end 3D performance at a mid range price: 15 million Gouraud shaded triangles per second, Optimized 3D drivers for MCAD and DCC applications, with user-customizable settings. 64MB DDR SDRAM unified frame buffer supporting true color at all supported standard resolutions.1511102061orderable9878http://www.supp-102061.com/cat/hw/p2411.html
1769GP 800×600Graphics processor, resolution 800 x 600 pixels. Remarkable value for users requiring great 2D capabilities or general 3D support for advanced applications. Drives incredible performance in highly complex models and frees the customer to focus on the design, instead of the rendering process.151-6102050orderable48 – http://www.supp-102050.com/cat/hw/p1769.html
2049MB – S300PC type motherboard, 300 Series.1521102082obsolete5547http://www.supp-102082.com/cat/hw/p2049.html
2751MB – S450PC type motherboard, 450 Series.1521102072orderable6654http://www.supp-102072.com/cat/hw/p2751.html
3112MB – S500PC type motherboard, 500 Series.152-5102086orderable7766http://www.supp-102086.com/cat/hw/p3112.html
2752MB – S550PC type motherboard for the 550 Series.152-5102086orderable8876http://www.supp-102086.com/cat/hw/p2752.html
2293MB – S600Motherboard, 600 Series.1522102086orderable9987http://www.supp-102086.com/cat/hw/p2293.html
3114MB – S900/650+PC motherboard, 900 Series; standard motherboard for all models 650 and up.1530102086under development10188http://www.supp-102086.com/cat/hw/p3114.html
3129Sound Card STDSound Card – standard version, with MIDI interface, line in/out, low impedance microphone input.151-6102090orderable4639http://www.supp-102090.com/cat/hw/p3129.html
3133Video Card /32Video Card, with 32MB cache memory.152-6102076orderable4841http://www.supp-102076.com/cat/hw/p3133.html
2308Video Card /E323-D ELSA Video Card, with 32 MB memory.152-6102087orderable5848http://www.supp-102087.com/cat/hw/p2308.html
2496WSP DA-130Wide storage processor DA-130 for storage subunits.1520102067planned299244http://www.supp-102067.com/cat/hw/p2496.html
2497WSP DA-290Wide storage processor (model DA-290).1530102053planned399355http://www.supp-102053.com/cat/hw/p2497.html
3106KB 101/ENStandard PC/AT Enhanced Keyboard (101/102-Key). Input locale: English (US).1611102066orderable4841http://www.supp-102066.com/cat/hw/p3106.html
2289KB 101/ESStandard PC/AT Enhanced Keyboard (101/102-Key). Input locale: Spanish.1611102055orderable4838http://www.supp-102055.com/cat/hw/p2289.html
3110KB 101/FRStandard PC/AT Enhanced Keyboard (101/102-Key). Input locale: French.1611102055orderable4839http://www.supp-102055.com/cat/hw/p3110.html
3108KB E/ENErgonomic Keyboard with two separate key areas, detachable numeric pad. Key layout: English (US).1622102055orderable7863http://www.supp-102055.com/cat/hw/p3108.html
2058Mouse +WPCombination of a mouse and a wrist pad for more comfortable typing and mouse operation.1611102055orderable2319http://www.supp-102055.com/cat/hw/p2058.html
2761Mouse +WP/CLSet consisting of a mouse and wrist pad, with corporate logo161-5102099planned2723http://www.supp-102099.com/cat/hw/p2761.html
3117Mouse C/EErgonomic, cordless mouse. With track-ball for maximum comfort and ease of use.1611102099orderable4135http://www.supp-102099.com/cat/hw/p3117.html
2056Mouse Pad /CLStandard mouse pad, with corporate logo1611102099planned86http://www.supp-102099.com/cat/hw/p2056.html
2211Wrist PadA foam strip to support your wrists when using a keyboard1611102072orderable43http://www.supp-102072.com/cat/hw/p2211.html
2944Wrist Pad /CLWrist Pad with corporate logo1611102063under development32http://www.supp-102063.com/cat/hw/p2944.html
1742CD-ROM 500/16xCD drive, read only, speed 16x, maximum capacity 500 MB.171-6102052orderable10181http://www.supp-102052.com/cat/hw/p1742.html
2402CD-ROM 600/E/24x600 MB external 24x speed CD-ROM drive (read only).172-9102052orderable127113http://www.supp-102052.com/cat/hw/p2402.html
2403CD-ROM 600/I/24x600 MB internal read only CD-ROM drive, reading speed 24x1721102052orderable117103http://www.supp-102052.com/cat/hw/p2403.html
1761CD-ROM 600/I/32x600 MB Internal CD-ROM Drive, speed 32x (read only).1721102052under development134119http://www.supp-102052.com/cat/hw/p1761.html
2381CD-ROM 8xCD Writer, read only, speed 8x171-3102052obsolete9982http://www.supp-102052.com/cat/hw/p2381.html
2424CDW 12/24CD Writer, speed 12x write, 24x read. Warning: will become obsolete very soon; this speed is not high enough anymore, and better alternatives are available for a reasonable price.172-6102075orderable221198http://www.supp-102075.com/cat/hw/p2424.html
1726LCD Monitor 11/PMLiquid Cristal Display 11 inch passive monitor. The virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.113-3102067under development259208http://www.www.supp-102067.com/cat/hw/p1726.html
2359LCD Monitor 9/PMLiquid Cristal Display 9 inch passive monitor. Enjoy the productivity that a small monitor can bring via more workspace on your desk. Easy setup with plug-and-play compatibility.113-3102061orderable249206http://www.www.supp-102061.com/cat/hw/p2359.html
3060Monitor 17/HRCRT Monitor 17 inch (16 viewable) high resolution. Exceptional image performance and the benefit of additional screen space. This monitor offers sharp, color-rich monitor performance at an incredible value. With a host of leading features, including on-screen display controls.114-6102081orderable299250http://www.supp-102081.com/cat/hw/p3060.html
3051Pens – 10/MPPermanent ink pen dries quickly and is smear resistant. Provides smooth, skip-free writing. Medium point. Single color boxes (black, blue, red) or assorted box (6 black, 3 blue, and 1 red).3210103097orderable1210http://www.supp-103097.com/cat/off/p3051.html
3150Card Holder – 25Card Holder; heavy plastic business card holder with embossed corporate logo. Holds about 25 of your business cards, depending on card thickness.321-6103089orderable1815http://www.supp-103089.com/cat/off/p3150.html
3208Pencils – WoodBox of 2 dozen wooden pencils. Specify lead type when ordering: 2H (double hard), H (hard), HB (hard black), B (soft black).3210103097orderable21http://www.supp-103097.com/cat/off/p3208.html
3209Sharpener – PencilElectric Pencil Sharpener Rugged steel cutters for long life. PencilSaver helps prevent over-sharpening. Non-skid rubber feet. Built-in pencil holder.3222103096orderable1311http://www.supp-103096.com/cat/off/p3209.html
3224Card Organizer – 250Portable holder for organizing business cards, capacity 250. Booklet style with slip in, transparent pockets for business cards. Optional alphabet tabs. Specify cover color when ordering (dark brown, beige, burgundy, black, and light grey).3215103095orderable3228http://www.supp-103095.com/cat/off/p3224.html
3225Card Organizer – 1000Holder for organizing business cards with alphabet dividers; capacity 1000. Desk top style with smoke grey cover and black base. Lid is removable for storing inside drawer.321-2103095orderable4739http://www.supp-103095.com/cat/off/p3225.html
3511Paper – HQ PrinterQuality paper for inkjet and laser printers tested to resist printer jams. Acid free for archival purposes. 22lb. weight with brightness of 92. Size: 8 1/2 x 11. Single 500-sheet ream.3220103080orderable97http://www.supp-103080.com/cat/off/p3511.html
3515Lead ReplacementRefill leads for mechanical pencils. Each pack contains 25 leads and a replacement eraser. Available in three lead sizes: .5mm (fine); .7mm (medium); and .9mm (thick).3210103095orderable21http://www.supp-103095.com/cat/off/p3515.html
2986Manual – Vision OS/2x +Manuals for Vision Operating System V 2.x and Vision Office Suite3330103095orderable125111http://www.supp-103095.com/cat/off/p2986.html
3163Manual – Vision Net6.3/USVision Networking V6.3 Reference Manual. US version with advanced encryption.3320103083orderable3529http://www.supp-103083.com/cat/off/p3163.html
3165Manual – Vision Tools2.0Vision Business Tools Suite V2.0 Reference Manual. Includes installation, configuration, and user guide.3320103083orderable4034http://www.supp-103083.com/cat/off/p3165.html
3167Manual – Vision OS/2.xVision Operating System V2.0/2.1/2/3 Reference Manual. Complete installation, configuration, management, and tuning information for Vision system administration. Note that this manual replaces the individual Version 2.0 and 2.1 manuals.3320103083orderable5547http://www.supp-103083.com/cat/off/p3167.html
3216Manual – Vision Net6.3Vision Networking V6.3 Reference Manual. Non-US version with basic encryption.3320103083orderable3026http://www.supp-103083.com/cat/off/p3216.html
3220Manual – Vision OS/1.2Vision Operating System V1.2 Reference Manual. Complete installation, configuration, management, and tuning information for Vision system administration.3320103083orderable4536http://www.supp-103083.com/cat/off/p3220.html
1729Chemicals – RCPCleaning Chemicals – 3500 roller clean pads3925103094orderable8066http://www.supp-103094.com/cat/off/p1729.html
1910FG Stock – HFiberglass Stock – heavy duty, 1 thick3930103083orderable1411http://www.supp-103083.com/cat/off/p1910.html
1912SS Stock – 3mmStainless steel stock – 3mm. Can be predrilled for standard power supplies, motherboard holders, and hard drives. Please use appropriate template to identify model number, placement, and size of finished sheet when placing order for drilled sheet.3920103083orderable1512http://www.supp-103083.com/cat/off/p1912.html
1940ESD Bracelet/ClipElectro static discharge bracelet with alligator clip for easy connection to computer chassis or other ground.391-5103095orderable1814http://www.supp-103095.com/cat/off/p1940.html
2030Latex GlovesLatex Gloves for assemblers, chemical handlers, fitters. Heavy duty, safety orange, with textured grip on fingers and thumb. Waterproof and shock-proof up to 220 volts/2 amps, 110 volts/5 amps. Acid proof for up to 5 minutes.39110103097orderable1210http://www.supp-103097.com/cat/off/p2030.html
2326Plastic Stock – YPlastic Stock – Yellow, standard quality.3910103093orderable21http://www.supp-103093.com/cat/off/p2326.html
2330Plastic Stock – RPlastic Stock – Red, standard quality.3910103093orderable21http://www.supp-103093.com/cat/off/p2330.html
2334ResinGeneral purpose synthetic resin.3920103087orderable43http://www.supp-103087.com/cat/off/p2334.html
2340Chemicals – SWCleaning Chemicals – 3500 staticide wipes3925103094orderable7259http://www.supp-103094.com/cat/off/p2340.html
2365Chemicals – TCSCleaning Chemical – 2500 transport cleaning sheets3935103094orderable7869http://www.supp-103094.com/cat/off/p2365.html
2594FG Stock – LFiberglass Stock – light weight for internal heat shielding, 1/4 thick3920103098orderable97http://www.supp-103098.com/cat/off/p2594.html
2596SS Stock – 1mmStainless steel stock – 3mm. Can be predrilled for standard model motherboard and battery holders. Please use appropriate template to identify model number, placement, and size of finished sheet when placing order for drilled sheet.3920103098orderable1210http://www.supp-103098.com/cat/off/p2596.html
2631ESD Bracelet/QRElectro Static Discharge Bracelet: 2 piece lead with quick release connector. One piece stays permanently attached to computer chassis with screw, the other is attached to the bracelet. Additional permanent ends available.391-5103085orderable1512http://www.supp-103085.com/cat/off/p2631.html
2721PC Bag – L/SBlack Leather Computer Case – single laptop capacity with pockets for manuals, additional hardware, and work papers. Adjustable protective straps and removable pocket for power supply and cables.3921103095orderable8770http://www.supp-103095.com/cat/off/p2721.html
2722PC Bag – L/DBlack Leather Computer Case – double laptop capacity with pockets for additional hardware or manuals and work papers. Adjustable protective straps and removable pockets for power supplies and cables. Double wide shoulder strap for comfort.3921103095orderable11299http://www.supp-103095.com/cat/off/p2722.html
2725Machine OilMachine Oil for Lubrication of CD-ROM drive doors and slides. Self-cleaning adjustable nozzle for fine to medium flow.3910103098orderable43http://www.supp-103098.com/cat/off/p2725.html
2782PC Bag – C/SCanvas Computer Case – single laptop capacity with pockets for manuals, additional hardware, and work papers. Adjustable protective straps and removable pocket for power supply and cables. Outside pocket with snap closure for easy access while travelling.392-6103095orderable6250http://www.supp-103095.com/cat/off/p2782.html
3187Plastic Stock – B/HDPlastic Stock – Blue, high density.3910103095orderable32http://www.supp-103095.com/cat/off/p3187.html
3189Plastic Stock – GPlastic Stock – Green, standard density.3910103095orderable21http://www.supp-103095.com/cat/off/p3189.html
3191Plastic Stock – OPlastic Stock – Orange, standard density.3910103095orderable21http://www.supp-103095.com/cat/off/p3191.html
3193Plastic Stock – W/HDPlastic Stock – White, high density.3910103095orderable32http://www.supp-103095.com/cat/off/p3193.html
3123PS 220V /DStandard power supply, 220V, for desktop computers.1921102062orderable8165http://www.supp-102062.com/cat/hw/p3123.html
1748PS 220V /EUR220 Volt Power supply type – Europe1921102053orderable8370http://www.supp-102053.com/cat/hw/p1748.html
2387PS 220V /FR220V Power supply type – France1921102053orderable8366http://www.supp-102053.com/cat/hw/p2387.html
2370PS 220V /HS/FR220V hot swappable power supply, for France.192-9102053orderable9175http://www.supp-102053.com/cat/hw/p2370.html
2311PS 220V /LPower supply for laptop computers, 220V192-9102053orderable9579http://www.supp-102053.com/cat/hw/p2311.html
1733PS 220V /UK220V Power supply type – United Kingdom192-9102080orderable8976http://www.supp-102080.com/cat/hw/p1733.html
2878Router – ASR/2WSpecial ALS Router – Approved Supplier required item with 2-way match193-9102063orderable345305http://www.supp-102063.com/cat/hw/p2878.html
2879Router – ASR/3WSpecial ALS Router – Approved Supplier required item with 3-way match193-9102063orderable456384http://www.supp-102063.com/cat/hw/p2879.html
2152Router – DTMF4DTMF 4 port router193-9102063obsolete231191http://www.supp-102063.com/cat/hw/p2152.html
3301Screws <B.28.P>Screws: Brass, size 28mm, Phillips head. Plastic box, contents 500.1920102071orderable1512http://www.supp-102071.com/cat/hw/p3301.html
3143Screws <B.28.S>Screws: Brass, size 28mm, straight. Plastic box, contents 500.1920102071orderable1613http://www.supp-102071.com/cat/hw/p3143.html
2323Screws <B.32.P>Screws: Brass, size 32mm, Phillips head. Plastic box, contents 400.1930102071orderable1814http://www.supp-102071.com/cat/hw/p2323.html
3134Screws <B.32.S>Screws: Brass, size 32mm, straight. Plastic box, contents 400.1930102071orderable1815http://www.supp-102071.com/cat/hw/p3134.html
3139Screws <S.16.S>Screws: Steel, size 16 mm, straight. Carton box, contents 750.1920102071orderable2117http://www.supp-102071.com/cat/hw/p3139.html
3300Screws <S.32.P>Screws: Steel, size 32mm, Phillips head. Plastic box, contents 400.1930102071orderable2319http://www.supp-102071.com/cat/hw/p3300.html
2316Screws <S.32.S>Screws: Steel, size 32mm, straight. Plastic box, contents 500.1930102074orderable2219http://www.supp-102074.com/cat/hw/p2316.html
3140Screws <Z.16.S>Screws: Zinc, length 16mm, straight. Carton box, contents 750.1920102074orderable2419http://www.supp-102074.com/cat/hw/p3140.html
2319Screws <Z.24.S>Screws: Zinc, size 24mm, straight. Carton box, contents 500.1920102074orderable2521http://www.supp-102074.com/cat/hw/p2319.html
2322Screws <Z.28.P>Screws: Zinc, size 28 mm, Phillips head. Carton box, contents 850.1920102076orderable2318http://www.supp-102076.com/cat/hw/p2322.html
3178Spreadsheet – SSP/V 2.0SmartSpread Spreadsheet, Professional Edition Version 2.0, for Vision Release 11.1 and 11.2. Shrink wrap includes CD-ROM containing advanced software and online documentation, plus printed manual, tutorial, and license registration.212-1103080orderable4537http://www.supp-103080.com/cat/sw/p3178.html
3179Spreadsheet – SSS/S 2.1SmartSpread Spreadsheet, Standard Edition Version 2.1, for SPNIX Release 4.0. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual and license registration.212-1103080orderable5044http://www.supp-103080.com/cat/sw/p3179.html
3182Word Processing – SWP/V 4.5SmartWord Word Processor, Professional Edition Version 4.5, for Vision Release 11.x. Shrink wrap includes CD-ROM, containing advanced software, printed manual, and license registration.222-3103093orderable6554http://www.supp-103093.com/cat/sw/p3182.html
3183Word Processing – SWS/V 4.5SmartWord Word Processor, Standard Edition Version 4.5, for Vision Release 11.x. Shrink wrap includes CD-ROM and license registration.222-1103093orderable5040http://www.supp-103093.com/cat/sw/p3183.html
3197Spreadsheet – SSS/V 2.1SmartSpread Spreadsheet, Standard Edition Version 2.1, for Vision Release 11.1 and 11.2. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual, tutorial, and license registration.212-1103080orderable4536http://www.supp-103080.com/cat/sw/p3197.html
3255Spreadsheet – SSS/CD 2.2BSmartSpread Spreadsheet, Standard Edition, Beta Version 2.2, for SPNIX Release 4.1. CD-ROM only.211-1103080orderable3530http://www.supp-103080.com/cat/sw/p3255.html
3256Spreadsheet – SSS/V 2.0SmartSpread Spreadsheet, Standard Edition Version 2.0, for Vision Release 11.0. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual, tutorial, and license registration.212-1103080orderable4034http://www.supp-103080.com/cat/sw/p3256.html
3260Word Processing – SWP/S 4.4SmartSpread Spreadsheet, Standard Edition Version 2.2, for SPNIX Release 4.x. Shrink wrap includes CD-ROM, containing software, plus printed manual and license registration.222-1103093orderable5041http://www.supp-103093.com/cat/sw/p3260.html
3262Spreadsheet – SSS/S 2.2SmartSpread Spreadsheet, Standard Edition Version 2.2, for SPNIX Release 4.1. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual and license registration.212-1103080under development5041http://www.supp-103080.com/cat/sw/p3262.html
3361Spreadsheet – SSP/S 1.5SmartSpread Spreadsheet, Standard Edition Version 1.5, for SPNIX Release 3.3. Shrink wrap includes CD-ROM containing advanced software and online documentation, plus printed manual, tutorial, and license registration.212-1103080orderable4034http://www.supp-103080.com/cat/sw/p3361.html
1799SPNIX3.3 – SLOperating System Software: SPNIX V3.3 – Base Server License. Includes 10 general licenses for system administration, developers, or users. No network user licensing. 2411103092orderable1000874http://www.supp-103092.com/cat/sw/p1799.html
1801SPNIX3.3 – ALOperating System Software: SPNIX V3.3 – Additional system administrator license, including network access.2411103092orderable10088http://www.supp-103092.com/cat/sw/p1801.html
1803SPNIX3.3 – DLOperating System Software: SPNIX V3.3 – Additional developer license.2411103092orderable6051http://www.supp-103092.com/cat/sw/p1803.html
1804SPNIX3.3 – UL/NOperating System Software: SPNIX V3.3 – Additional user license with network access.2411103092orderable6556http://www.supp-103092.com/cat/sw/p1804.html
1805SPNIX3.3 – UL/AOperating System Software: SPNIX V3.3 – Additional user license class A.2411103092orderable5042http://www.supp-103092.com/cat/sw/p1805.html
1806SPNIX3.3 – UL/COperating System Software: SPNIX V3.3 – Additional user license class C.2411103092orderable5042http://www.supp-103092.com/cat/sw/p1806.html
1808SPNIX3.3 – UL/DOperating System Software: SPNIX V3.3 – Additional user license class D.2411103092orderable5546http://www.supp-103092.com/cat/sw/p1808.html
1820SPNIX3.3 – NLOperating System Software: SPNIX V3.3 – Additional network access license.2411103092orderable5545http://www.supp-103092.com/cat/sw/p1820.html
1822SPNIX4.0 – SLOperating System Software: SPNIX V4.0 – Base Server License. Includes 10 general licenses for system administration, developers, or users. No network user licensing. 2411103092orderable15001303http://www.supp-103092.com/cat/sw/p1822.html
2422SPNIX4.0 – SALOperating System Software: SPNIX V4.0 – Additional system administrator license, including network access.2411103092orderable150130http://www.supp-103092.com/cat/sw/p2422.html
2452SPNIX4.0 – DLOperating System Software: SPNIX V4.0 – Additional developer license.2411103092orderable10088http://www.supp-103092.com/cat/sw/p2452.html
2462SPNIX4.0 – UL/NOperating System Software: SPNIX V4.0 – Additional user license with network access.2411103092orderable8071http://www.supp-103092.com/cat/sw/p2462.html
2464SPNIX4.0 – UL/AOperating System Software: SPNIX V4.0 – Additional user license class A.2411103092orderable7062http://www.supp-103092.com/cat/sw/p2464.html
2467SPNIX4.0 – UL/DOperating System Software: SPNIX V4.0 – Additional user license class D.2411103092orderable8064http://www.supp-103092.com/cat/sw/p2467.html
2468SPNIX4.0 – UL/COperating System Software: SPNIX V4.0 – Additional user license class C.2411103092orderable7567http://www.supp-103092.com/cat/sw/p2468.html
2470SPNIX4.0 – NLOperating System Software: SPNIX V4.0 – Additional network access license.2411103092orderable8070http://www.supp-103092.com/cat/sw/p2470.html
2471SPNIX3.3 SUOperating System Software: SPNIX V3.3 – Base Server License Upgrade to V4.0.2411103092orderable500439http://www.supp-103092.com/cat/sw/p2471.html
2492SPNIX3.3 AUOperating System Software: SPNIX V3.3 – V4.0 upgrade; class A user.2411103092orderable4538http://www.supp-103092.com/cat/sw/p2492.html
2493SPNIX3.3 C/DUOperating System Software: SPNIX V3.3 – V4.0 upgrade; class C or D user.2411103092orderable2522http://www.supp-103092.com/cat/sw/p2493.html
2494SPNIX3.3 NUOperating System Software: SPNIX V3.3 – V4.0 upgrade; network access license.2411103092orderable2520http://www.supp-103092.com/cat/sw/p2494.html
2995SPNIX3.3 SAUOperating System Software: SPNIX V3.3 – V4.0 upgrade; system administrator license.2411103092orderable7062http://www.supp-103092.com/cat/sw/p2995.html
3290SPNIX3.3 DUOperating System Software: SPNIX V3.3 – V4.0 upgrade; developer license.2411103092orderable6555http://www.supp-103092.com/cat/sw/p3290.html
1778C for SPNIX3.3 – 1 SeatC programming software for SPNIX V3.3 – single user251-6103092orderable6252http://www.supp-103092.com/cat/sw/p1778.html
1779C for SPNIX3.3 – DocC programming language documentation, SPNIX V3.325210103092orderable128112http://www.supp-103092.com/cat/sw/p1779.html
1780C for SPNIX3.3 – SysC programming software for SPNIX V3.3 – system compiler, libraries, linker251-6103092orderable450385http://www.supp-103092.com/cat/sw/p1780.html
2371C for SPNIX4.0 – DocC programming language documentation, SPNIX V4.025210103092orderable146119http://www.supp-103092.com/cat/sw/p2371.html
2423C for SPNIX4.0 – 1 SeatC programming software for SPNIX V4.0 – single user251-6103092orderable8473http://www.supp-103092.com/cat/sw/p2423.html
3501C for SPNIX4.0 – SysC programming software for SPNIX V4.0 – system compiler, libraries, linker251-6103092orderable555448http://www.supp-103092.com/cat/sw/p3501.html
3502C for SPNIX3.3 -Sys/UC programming software for SPNIX V3.3 – 4.0 Upgrade; system compiler, libraries, linker251-6103092orderable10588http://www.supp-103092.com/cat/sw/p3502.html
3503C for SPNIX3.3 – Seat/UC programming software for SPNIX V3.3 – 4.0 Upgrade – single user251-6103092orderable2218http://www.supp-103092.com/cat/sw/p3503.html
1774Base ISO CP – BLBase ISO Communication Package – Base License2910103088orderable11093http://www.supp-103088.com/cat/sw/p1774.html
1775Client ISO CP – SISO Communication Package add-on license for additional SPNIX V3.3 client.2910103087orderable2722http://www.supp-103087.com/cat/sw/p1775.html
1794OSI 8-16/ILOSI Layer 8 to 16 – Incremental License2910103096orderable128112http://www.supp-103096.com/cat/sw/p1794.html
1825X25 – 1 Line LicenseX25 network access control system, single user291-6103093orderable2521http://www.supp-103093.com/cat/sw/p1825.html
2004IC Browser – SIC Web Browser for SPNIX. Browser with network mail capability.291-1103086orderable9080http://www.supp-103086.com/cat/sw/p2004.html
2005IC Browser Doc – SDocumentation set for IC Web Browser for SPNIX. Includes Installation Manual, Mail Server Administration Guide, and User Quick Reference.2920103086orderable115100http://www.supp-103086.com/cat/sw/p2005.html
2416Client ISO CP – SISO Communication Package add-on license for additional SPNIX V4.0 client.2910103088orderable4136http://www.supp-103088.com/cat/sw/p2416.html
2417Client ISO CP – VISO Communication Package add-on license for additional Vision client.2910103088orderable3327http://www.supp-103088.com/cat/sw/p2417.html
2449OSI 1-4/ILOSI Layer 1 to 4 – Incremental License2910103088orderable8372http://www.supp-103088.com/cat/sw/p2449.html
3101IC Browser – VIC Web Browser for Vision with manual. Browser with network mail capability.292-1103086orderable7567http://www.supp-103086.com/cat/sw/p3101.html
3170Smart Suite – V/SPOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. Spanish language software and user manuals.292-6103089orderable161132http://www.supp-103089.com/cat/sw/p3170.html
3171Smart Suite – S3.3/ENOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX Version 3.3. English language software and user manuals.292-6103089orderable148120http://www.supp-103089.com/cat/sw/p3171.html
3172Graphics – DIK+Software Kit Graphics: Draw-It Kwik-Plus. Includes extensive clip art files and advanced drawing tools for 3-D object manipulation, variable shading, and extended character fonts.291-1103094orderable4234http://www.supp-103094.com/cat/sw/p3172.html
3173Graphics – SASoftware Kit Graphics: SmartArt. Professional graphics package for SPNIX with multiple line styles, textures, built-in shapes and common symbols.291-1103094orderable8672http://www.supp-103094.com/cat/sw/p3173.html
3175Project Management – S4.0Project Management Software, for SPNIX V4.0. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.291-1103089orderable3732http://www.supp-103089.com/cat/sw/p3175.html
3176Smart Suite – V/ENOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. English language software and user manuals.292-6103089orderable120103http://www.supp-103089.com/cat/sw/p3176.html
3177Smart Suite – V/FROffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. French language software and user manuals.292-6103089orderable120102http://www.supp-103089.com/cat/sw/p3177.html
3245Smart Suite – S4.0/FROffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. French language software and user manuals.292-6103089orderable222195http://www.supp-103089.com/cat/sw/p3245.html
3246Smart Suite – S4.0/SPOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. Spanish language software and user manuals.292-6103089orderable222193http://www.supp-103089.com/cat/sw/p3246.html
3247Smart Suite – V/DEOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. German language software and user manuals.292-6103089orderable12096http://www.supp-103089.com/cat/sw/p3247.html
3248Smart Suite – S4.0/DEOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. German language software and user manuals.292-6103089orderable222193http://www.supp-103089.com/cat/sw/p3248.html
3250Graphics – DIKSoftware Kit Graphics: Draw-It Kwik. Simple graphics package for Vision systems, with options to save in GIF, JPG, and BMP formats.291-1103083orderable2824http://www.supp-103083.com/cat/sw/p3250.html
3251Project Management – VProject Management Software, for Vision. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.291-1103093orderable3126http://www.supp-103093.com/cat/sw/p3251.html
3252Project Management – S3.3Project Management Software, for SPNIX V3.3. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.291-1103093orderable2623http://www.supp-103093.com/cat/sw/p3252.html
3253Smart Suite – S4.0/ENOffice Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. English language software and user manuals.292-6103089orderable222188http://www.supp-103089.com/cat/sw/p3253.html
3257Web Browser – SB/S 2.1Software Kit Web Browser: SmartBrowse V2.1 for SPNIX V3.3. Includes context sensitive help files and online documentation.291-1103082orderable6658http://www.supp-103082.com/cat/sw/p3257.html
3258Web Browser – SB/V 1.0Software Kit Web Browser: SmartBrowse V2.1 for Vision. Includes context sensitive help files and online documentation.291-1103082orderable8070http://www.supp-103082.com/cat/sw/p3258.html
3362Web Browser – SB/S 4.0Software Kit Web Browser: SmartBrowse V4.0 for SPNIX V4.0. Includes context sensitive help files and online documentation.291-1103082orderable9981http://www.supp-103082.com/cat/sw/p3362.html
2231Desk – S/VStandard-sized desk; capitalizable, taxable item. Final finish is from veneer in stock at time of order, including oak, ash, cherry, and mahogany.31515103082orderable25102114http://www.supp-103082.com/cat/off/p2231.html
2335Mobile phoneDual band mobile phone with low battery consumption. Lightweight, foldable, with socket for single earphone and spare battery compartment.311-5103088orderable10083http://www.supp-103088.com/cat/off/p2335.html
2350Desk – W/48Desk – 48 inch white laminate without return; capitalizable, taxable item.31520103082orderable25002129http://www.supp-103082.com/cat/off/p2350.html
2351Desk – W/48/RDesk – 60 inch white laminate with 48 inch return; capitalizable, taxable item.31520103082orderable29002386http://www.supp-103082.com/cat/off/p2351.html
2779Desk – OS/O/FExecutive-style oversized oak desk with file drawers. Final finish is customizable when ordered, light or dark oak stain, or natural hand rubbed clear.31525103082orderable39803347http://www.supp-103082.com/cat/off/p2779.html
3337Mobile Web PhoneMobile phone including monthly fee for Web access. Slimline shape with leather-look carrying case and belt clip.312-5103088orderable800666http://www.supp-103088.com/cat/off/p3337.html
2091Paper Tablet LW 8 1/2 x 11Paper tablet, lined, white, size 8 1/2 x 11 inch3210103095orderable10http://www.supp-103095.com/cat/off/p2091.html
2093Pens – 10/FPPermanent ink pen dries quickly and is smear resistant. Provides smooth, skip-free writing. Fine point. Single color boxes (black, blue, red) or assorted box (6 black, 3 blue, and 1 red).3210103090orderable87http://www.supp-103090.com/cat/off/p2093.html
2144Card Organizer CoverReplacement cover for desk top style business card holder. Smoke grey (original color) or clear plastic.321-1103094orderable1814http://www.supp-103094.com/cat/off/p2144.html
2336Business Cards Box – 250Business cards box, capacity 250. Use form BC110-2, Rev. 3/2000 (hardcopy or online) when ordering and complete all fields marked with an asterisk.3210103091orderable5549http://www.supp-103091.com/cat/off/p2336.html
2337Business Cards – 1000/2LBusiness cards box, capacity 1000, 2-sided with different language on each side. Use form BC111-2, Rev. 12/1999 (hardcopy or online) when ordering – complete all fields marked with an asterisk and check box for second language (English is always on side 1).3210103091orderable300246http://www.supp-103091.com/cat/off/p2337.html
2339Paper – Std Printer20 lb. 8.5×11 inch white laser printer paper (recycled), ten 500-sheet reams3230103095orderable2521http://www.supp-103095.com/cat/off/p2339.html
2536Business Cards – 250/2LBusiness cards box, capacity 250, 2-sided with different language on each side. Use form BC111-2, Rev. 12/1999 (hardcopy or online) when ordering – complete all fields marked with an asterisk and check box for second language (English is always on side 1).3210103091orderable8068http://www.supp-103091.com/cat/off/p2536.html
2537Business Cards Box – 1000Business cards box, capacity 1000. Use form BC110-3, Rev. 3/2000 (hardcopy or online) when ordering and complete all fields marked with an asterisk.3210103091orderable200176http://www.supp-103091.com/cat/off/p2537.html
2783Clips – PaperWorld brand paper clips set the standard for quality.10 boxes with 100 clips each. #1 regular or jumbo, smooth or non-skid.3220103080orderable108http://www.supp-103080.com/cat/off/p2783.html
2808Paper Tablet LY 8 1/2 x 11Paper Tablet, Lined, Yellow, size 8 1/2 x 11 inch3210103098orderable10http://www.supp-103098.com/cat/off/p2808.html

Problem 1
Write a query that retrieves, for each customer’s first and last order, the details of the orders. If a customer has placed more than one order, then for the corresponding customer, two rows should be returned, otherwise one row. One for the first order and another for the last order (most recent). For each order, include the customer ID, order ID, order date, order total, and a list of products ordered in the output. Use semi-colons as the separator for each order’s product listing.

Strategy
Break the problem down into the following three subproblems:
1. Retrieve the first and last order for each customer. Include the customer ID, order ID, and order date in the output. See first_last_order CTE.

2. Retrieve the order total for each order. Include the order ID and corresponding order total in the output. See order_total CTE.

3. Retrieve a list of products ordered for each order. Include the order ID and list of products in the output. Each product in a list should be separated by a semi-colon. See product_concatenated CTE.

Finally, bring the solutions to each subproblem together to solve the overall problem. For clarity, see the code and corresponding output below.

WITH first_last_order AS (
    SELECT
		order_data.customer_id,
		order_data.order_id,
		order_data.order_date,
		order_data.order_date_sequence_asc,
		order_data.order_date_sequence_desc
    FROM (
        SELECT
			oe.orders.customer_id,
			oe.orders.order_id,
			oe.orders.order_date,
			DENSE_RANK() OVER (
				PARTITION BY oe.orders.customer_id
				ORDER BY oe.orders.order_date
			) AS order_date_sequence_asc,
			DENSE_RANK() OVER (
				PARTITION BY oe.orders.customer_id
				ORDER BY oe.orders.order_date DESC
			) AS order_date_sequence_desc
        FROM
			oe.orders
    ) order_data
    WHERE
		order_data.order_date_sequence_asc = 1
        OR order_data.order_date_sequence_desc = 1
),
order_total AS (
    SELECT
		oe.order_items.order_id,
		SUM(oe.order_items.unit_price * oe.order_items.quantity) AS order_total
    FROM
		oe.order_items
    GROUP BY
		oe.order_items.order_id
),
product_concatenated AS (
    SELECT
		oe.order_items.order_id,
		LISTAGG(oe.product_information.product_name, '; ' ON OVERFLOW TRUNCATE) WITHIN GROUP (
			ORDER BY oe.product_information.list_price DESC
		) AS product_list
    FROM
		oe.order_items
        INNER JOIN
		oe.product_information
            ON oe.order_items.product_id = oe.product_information.product_id
    GROUP BY
		oe.order_items.order_id
)
SELECT
	first_last_order.customer_id,
	first_last_order.order_id,
	first_last_order.order_date,
	order_total.order_total,
	product_concatenated.product_list
FROM
	first_last_order
    INNER JOIN
	order_total
        ON first_last_order.order_id = order_total.order_id
    INNER JOIN
	product_concatenated
        ON first_last_order.order_id = product_concatenated.order_id;
customer_idorder_idorder_dateorder_totalproduct_list
104235414-JUL-08 06.18.23.234567 PM46257Smart Suite – V/SP; Smart Suite – V/EN; MB – S900/650+; PS 220V /D; Word Processing – SWP/V 4.5; Manual – Vision OS/2.x; KB 101/EN; Sound Card STD; Manual – Vision Tools2.0; Manual – Vision Net6.3/US; Screws <S.16.S>; Card Holder – 25; Screws <B.28.S>
104235526-JAN-06 09.22.51.962632 AM94513.5LCD Monitor 9/PM; PS 220V /L; Video Card /E32; KB 101/ES; Paper – Std Printer; Screws <Z.28.P>; Screws <B.32.P>; Plastic Stock – R; Plastic Stock – Y
105235626-JAN-08 09.22.41.934562 AM29473.8CDW 20/48/I; RAM – 32 MB; MB – S600; PS 220V /L; PS 12V /P; Video Card /E32; Screws <S.32.S>; Screws <B.32.P>
108235708-JAN-06 08.19.44.123456 PM59872.4Monitor 21/HR/M; Monitor 19/SD/M; HD 8GB /I; SDRAM – 48 MB; ZIP 100; Modem – 56/H/E; KB 101/ES; Wrist Pad
107236014-NOV-07 12.22.31.223344 PM990.4Mouse +WP; Pens – 10/FP
108236113-NOV-07 01.34.21.986210 PM120131.3LCD Monitor 9/PM; PS 220V /L; Chemicals – TCS; PS 12V /P; Video Card /E32; KB 101/ES; Screws <S.32.S>; Resin; Plastic Stock – Y
148236727-JUN-08 09.53.32.335522 PM144054.8Desk – W/48; Inkjet B/6; Mobile phone; Video Card /E32; KB 101/ES; Screws <Z.28.P>; Plastic Stock – R; Plastic Stock – Y
149236826-JUN-08 10.19.43.190089 PM60065LaserPro 600/6/BW; PS 220V /D; Monitor Hinge – HD; KB 101/EN; KB 101/FR; Sound Card STD; Mouse C/E; Screws <B.28.S>
116236926-JUN-07 11.22.54.009932 PM11097.4Smart Suite – V/SP; Envoy DS; Smart Suite – V/EN; Monitor Hinge – HD; Manual – Vision Tools2.0; Manual – Vision Net6.3/US; Card Holder – 25; Plastic Stock – B/HD; Plastic Stock – W/HD
117237027-JUN-08 12.22.11.647398 AM126FG Stock – H
118237116-MAY-07 01.34.56.113356 AM79405.6Desk – W/48; RAM – 32 MB; MB – S600; PS 12V /P; Paper – Std Printer; Screws <S.32.S>; Screws <B.32.P>; Resin
119237227-FEB-07 12.22.33.356789 AM16447.2LaserPro 600/6/BW; Smart Suite – V/SP; PS 220V /D; KB E/EN; Manual – Vision OS/2.x; KB 101/EN; KB 101/FR; Manual – Vision Net6.3/US; Screws <B.32.S>; Screws <B.28.S>
120237327-FEB-08 01.34.51.220065 AM416SPNIX3.3 – NL; X25 – 1 Line License
121237427-FEB-08 02.41.45.109654 AM4797SPNIX4.0 – SAL; C for SPNIX4.0 – 1 Seat; OSI 1-4/IL; SPNIX4.0 – UL/D
122237526-FEB-07 03.49.50.459233 AM103834.4LaserPro 600/6/BW; Smart Suite – S3.3/EN; Smart Suite – V/EN; MB – S500; Monitor Hinge – HD; KB 101/EN; Video Card /32; Mouse C/E; Manual – Vision Tools2.0; Manual – Vision Net6.3/US; Card Holder – 25; Screws <B.32.S>; Screws <B.28.S>
123237607-JUN-07 06.18.08.883310 AM11006.2SDRAM – 48 MB; Inkjet B/6; MB – S600; PS 220V /L; PS 12V /P; Modem – 56/90/I; Screws <Z.24.S>; Screws <S.32.S>; Resin; Plastic Stock – Y
141237707-JUN-07 07.03.01.001100 AM38017.8Inkjet B/6; PS 220V /L; KB 101/ES; Screws <Z.24.S>; Plastic Stock – R; Plastic Stock – Y
142237824-MAY-07 08.59.10.010101 AM25691.3LaserPro 1200/8/BW; HD 9.1GB @10000 /I; CDW 12/24; CD-ROM 600/I/24x; 8MB EDO Memory; C for SPNIX4.0 – 1 Seat; Client ISO CP – V; Cable PR/S/6
146237916-MAY-07 02.22.24.234567 AM17848.2LaserPro 600/6/BW; MB – S900/650+; KB 101/EN; Screws <Z.16.S>; Screws <S.16.S>
143238016-MAY-07 09.53.02.909090 AM27132.6LaserPro 600/6/BW; Smart Suite – V/EN; KB E/EN; Manual – Vision OS/2.x; Monitor Hinge – HD; KB 101/EN; Video Card /32; Mouse C/E; Manual – Vision Net6.3/US; Screws <Z.16.S>; Card Holder – 25; Screws <B.28.S>; Plastic Stock – B/HD
144238214-MAY-08 10.19.03.828321 AM71173LaserPro 600/6/BW; MB – S900/650+; PS 220V /D; KB 101/EN; KB 101/FR; Sound Card STD; Mouse C/E; Manual – Vision Tools2.0; Manual – Vision Net6.3/US; Screws <S.16.S>; Screws <B.28.S>
145238312-MAY-08 11.22.30.545103 AM36374.7TD 7GB/8; Compact 400/LQ; SPNIX4.0 – SAL; CPU D400; SPNIX4.0 – UL/N; Battery Backup (DA-130); Cable PR/S/6
146238412-MAY-08 12.22.34.525972 PM29249.1LCD Monitor 9/PM; PS 12V /P; KB 101/ES; Screws <Z.28.P>; Screws <S.32.S>; Plastic Stock – R
147238508-DEC-07 11.34.11.331392 AM295892Desk – W/48; Inkjet B/6; Mobile phone; PS 220V /L; KB 101/ES; Screws <Z.24.S>
149238711-MAR-07 03.34.56.536966 PM52758.9Monitor 21/HR/M; Monitor 19/SD/M; HD 10GB @5400 /SE; Monitor 17/HR/F; Modem – 56/H/E; Wrist Pad
150238804-JUN-07 04.41.12.554435 PM282694.3Desk – W/48; MB – S600; Video Card /E32; KB 101/ES; Plastic Stock – R
151238904-JUN-08 05.49.43.546954 PM17620PS 220V /D; MB – S500; Manual – Vision OS/2.x; Monitor Hinge – HD; KB 101/EN; Sound Card STD; Manual – Vision Tools2.0; Screws <B.28.S>
152239018-NOV-07 04.18.50.546851 PM7616.8Envoy IC/58; SS Stock – 3mm; FG Stock – H
153239127-FEB-06 05.03.03.828330 PM48070.6SPNIX4.0 – SL; SPNIX3.3 – SL; Inkjet C/8/HQ; Industrial 700/HD; CPU D300; SPNIX3.3 – NL; SPNIX3.3 – UL/D
154239221-JUL-07 08.59.57.571057 PM26632PS 110V /T; MB – S500; Monitor Hinge – HD; KB 101/EN; Video Card /32; Mouse C/E; Manual – Vision Tools2.0; Screws <S.16.S>; Card Holder – 25
155239310-FEB-08 07.53.19.528202 PM23431.9Monitor 21/SD; HD 10GB /S; Monitor 17/HR; VRAM – 64 MB; DVD 8x; VRAM – 16 MB; DIMM – 16 MB; Modem – 56/90/E; KB E/EN; Pens – 10/MP; Cable Harness
109239410-FEB-08 09.22.35.564789 PM21863PS 110V /T; PS 220V /D; Manual – Vision OS/2.x; Monitor Hinge – HD; Video Card /32; Sound Card STD; Mouse C/E; Screws <Z.16.S>; Screws <B.32.S>
156239502-FEB-06 08.19.11.227550 PM68501Monitor 21/HR/M; HD 12GB @7200 /SE; Monitor 17/HR/F; CDW 20/48/I; Modem – 56/H/E; Modem – 56/90/I; Wrist Pad
147239602-FEB-06 01.34.56.345678 AM34930MB – S900/650+; KB E/EN; Monitor Hinge – HD; KB 101/EN; KB 101/FR; Manual – Vision Net6.3/US; Screws <Z.16.S>; Card Holder – 25
102239719-NOV-07 02.41.54.696211 PM42283.2Laptop 32/10/56; Laptop 16/8/110; Manual – Vision OS/2x +; Drive Mount – D
157239819-NOV-07 09.22.53.224175 PM7110.3SPNIX3.3 SU; Business Cards Box – 1000; FG Stock – L
158239919-NOV-07 10.22.38.340990 PM25270.3LCD Monitor 9/PM; Inkjet B/6; Mobile phone; MB – S600; PS 220V /L; PS 12V /P; Video Card /E32; KB 101/ES; Screws <S.32.S>; Plastic Stock – R; Plastic Stock – Y
159240010-JUL-07 01.34.29.559387 AM69286.4Laptop 128/12/56/v90/110; Laptop 16/8/110; Manual – Vision OS/2x +; Drive Mount – D; Drive Mount – A
160240110-JUL-07 02.22.53.554822 AM969.2WSP DA-130; SPNIX3.3 AU
161240202-JUL-07 03.34.44.665170 AM600Business Cards – 250/2L
162240301-JUL-07 04.49.13.615512 PM220Battery – EL
163240401-JUL-07 04.49.13.664085 PM510PC Bag – L/S; Paper Tablet LY 8 1/2 x 11
164240501-JUL-07 04.49.13.678123 PM1233Envoy DS/E
165240729-JUN-07 07.03.21.526005 AM2519MB – S550; PC Bag – L/S; Mouse +WP/CL
166240829-JUN-07 08.59.31.333617 AM309MB – S450; Mouse +WP/CL; Clips – Paper
167240929-JUN-07 09.53.41.984501 AM48Inkvisible Pens
168241024-MAY-08 10.19.51.985501 AM45175Laptop 128/12/56/v90/110; Manual – Vision OS/2x +; SPNIX3.3 SAU; Drive Mount – D; Drive Mount – A; Pens – 10/MP
169241124-MAY-07 11.22.10.548639 AM15760.5LaserPro 600/6/BW; VRAM – 16 MB; PS 110V /T; Modem – 56/90/E; PS 220V /D; MB – S500; IC Browser – V; KB 101/EN; Video Card /32; Screws <B.28.S>; Cable Harness; Cable Connector – 32R
170241229-MAR-06 10.22.09.509801 AM66816LaserPro 600/6/BW; MB – S900/650+; PS 220V /D; Manual – Vision OS/2.x; KB 101/EN; Manual – Vision Net6.3/US; Screws <S.16.S>; Screws <B.32.S>; Screws <B.28.S>
103241529-MAR-06 01.34.50.545196 PM310MB – S450
105241720-MAR-07 05.49.10.974352 PM1926.6Drive Mount – D; Pencil – Mech
106241820-MAR-04 04.18.21.862632 PM5546.6RAM – 48 MB; Modem – 56/90/E; KB 101/FR; Screws <Z.16.S>; Card Holder – 25; Cable Connector – 32R
109242112-MAR-07 09.53.54.562432 PM72836PS 220V /D; KB E/EN; MB – S500; Monitor Hinge – HD; KB 101/EN; Sound Card STD; Mouse C/E; Card Holder – 25; Screws <B.28.S>
148242617-NOV-06 12.22.11.262552 AM7200Smart Suite – S4.0/DE; Monitor Hinge – STD; Manual – Vision Net6.3; Project Management – S3.3; Plastic Stock – W/HD
116242810-NOV-07 02.41.34.463567 AM14685.8LaserPro 600/6/BW; Smart Suite – V/SP; MB – S900/650+; Graphics – SA; PS 220V /D; KB E/EN; KB 101/EN; Video Card /32; Mouse C/E; Card Holder – 25; Screws <B.28.S>
102243114-SEP-06 07.03.04.763452 AM5610.6LaserPro 600/6/BW; MB – S900/650+; KB 101/EN; Sound Card STD; Mouse C/E; Cable Connector – 32R
106244101-AUG-08 11.22.48.734526 AM2075.2Business Cards Box – 1000; Business Cards – 250/2L
107244227-JUL-06 12.22.59.662632 PM52471.9LaserPro 1200/8/BW; HD 8.4GB @5400; Compact 400/LQ; SPNIX4.0 – SAL; CD-ROM 600/E/24x; CPU D400; SPNIX4.0 – UL/D; Battery Backup (DA-130)
144244527-JUL-06 03.34.38.362632 PM5537.8MB – S600; PS 220V /L; PS 12V /P; Modem – 56/90/I; Battery – NiHM; Screws <Z.24.S>; Plastic Stock – Y
101244727-JUL-08 08.59.10.223344 AM33893.6DVD 12x; CDW 20/48/I; Inkjet B/6; RAM – 16 MB; MB – S600; PS 220V /L; PS 12V /P; Video Card /E32; Battery – NiHM
145244818-JUN-07 04.41.49.262632 PM1388MB – S900/650+; KB 101/EN; Video Card /32; Screws <S.16.S>; Screws <B.32.S>; Screws <B.28.S>
103245402-OCT-07 05.49.34.678340 PM6653.4MB – S600; PS 12V /P; Video Card /E32; KB 101/ES; Screws <S.32.S>; Screws <B.32.P>; Resin
117245607-NOV-06 07.53.25.989889 PM3878.4Business Cards Box – 1000; Battery – EL
118245731-OCT-07 11.22.16.162632 PM21586.2LaserPro 600/6/BW; Smart Suite – V/SP; PS 220V /D; KB E/EN; Monitor Hinge – HD; Graphics – DIK+; Card Holder – 25
101245816-AUG-07 03.34.12.234359 PM78279.6LaserPro 600/6/BW; PS 220V /D; Mouse C/E; Manual – Vision Net6.3/US; Screws <B.32.S>; Screws <B.28.S>

A “CTE-less” solution resulting in the same output can be found below.

SELECT
	order_data.customer_id,
	order_data.order_id,
	order_data.order_date,
	order_data.product_list
FROM (
    SELECT
		oe.orders.customer_id,
		oe.orders.order_id,
		oe.orders.order_date,
		oe.orders.order_total,
		product_concatenated.product_list,
		DENSE_RANK() OVER (
			PARTITION BY oe.orders.customer_id
			ORDER BY oe.orders.order_date
		) AS order_date_sequence_asc,
		DENSE_RANK() OVER (
			PARTITION BY oe.orders.customer_id
			ORDER BY oe.orders.order_date DESC
		) AS order_date_sequence_desc
    FROM
		oe.orders
        INNER JOIN (
		SELECT
			oe.order_items.order_id,
			SUM(oe.order_items.unit_price * oe.order_items.quantity) AS order_total
		FROM
			oe.order_items
		GROUP BY
			oe.order_items.order_id
        ) order_total
            ON oe.orders.order_id = order_total.order_id
        INNER JOIN (
		SELECT
			oe.order_items.order_id,
			LISTAGG(oe.product_information.product_name, '; ' ON OVERFLOW TRUNCATE)
			WITHIN GROUP (
				ORDER BY oe.product_information.list_price DESC
			) AS product_list
		FROM
			oe.order_items
			INNER JOIN
			oe.product_information
				ON oe.order_items.product_id = oe.product_information.product_id
		GROUP BY
			oe.order_items.order_id
        )  product_concatenated
            ON oe.orders.order_id = product_concatenated.order_id
) order_data
WHERE
	order_data.order_date_sequence_asc = 1
	OR order_data.order_date_sequence_desc = 1;

Problem 2
The order entry data contains orders that span from March 2004 to August 2008. Write a query that retrieves, for each month from March 2004 to August 2008, the number of orders placed, the most popular product based on quantity ordered, the sum of all order totals, and total quantity ordered.

Strategy
Break the problem down into the following three subproblems:

1. Create a list of dates, in the format YYYY-MM-01 by truncating the month (i.e., 4-digit year, 2-digit month, 01 day), spanning from March 2004 to August 2008. See recursive CTE, calendar.

2. For each month, retrieve the total quantity ordered of products and the order total across all orders. Include the order date (grouped by month) in the same format as those generated in subproblem 1, the quantity total, and order total in the output. See monthly_order_summary CTE.

3. For each month, retrieve the product ordered the most in terms of quantity ordered. Include the order date (grouped by month) in the same format as those generated in subproblem 1, the product name, and total quantity ordered. See monthly_top_product CTE.

Finally, bring the solutions to each subproblem together to solve the overall problem. For clarity, see the code and corresponding output below.

WITH calendar (reporting_month) AS (
    SELECT
    	TRUNC(MIN(oe.orders.order_date), 'MONTH')
    FROM
    	oe.orders
	UNION ALL
    SELECT
    	ADD_MONTHS(calendar.reporting_month, 1)
    FROM
    	calendar
    WHERE
    	calendar.reporting_month < (
			SELECT
				TRUNC(MAX(oe.orders.order_date), 'MONTH')
			FROM
				oe.orders
		)
),
monthly_order_summary AS (
    SELECT
		TRUNC(oe.orders.order_date, 'MONTH') AS order_date,
		SUM(oe.order_items.quantity) AS quantity_total,
		SUM(oe.order_items.quantity * oe.order_items.unit_price) AS order_total
    FROM
		oe.orders
        INNER JOIN
		oe.order_items
            ON oe.orders.order_id = oe.order_items.order_id
    GROUP BY
		TRUNC(oe.orders.order_date, 'MONTH')
),
monthly_top_product AS (
    SELECT
		product_popularity.order_date,
		product_popularity.product_name,
		product_popularity.total_ordered
    FROM (
        SELECT
			TRUNC(oe.orders.order_date, 'MONTH') AS order_date,
			oe.product_information.product_name,
			SUM(oe.order_items.quantity) AS total_ordered,
			DENSE_RANK() OVER (
				PARTITION BY TRUNC(oe.orders.order_date, 'MONTH')
				ORDER BY SUM(oe.order_items.quantity) DESC
			) popularity_sequence
        FROM
			oe.orders
            INNER JOIN
			oe.order_items
				ON oe.orders.order_id = oe.order_items.order_id
            INNER JOIN
			oe.product_information
                ON oe.order_items.product_id = oe.product_information.product_id
        GROUP BY
			TRUNC(oe.orders.order_date, 'MONTH'),
			oe.product_information.product_name
    ) product_popularity
    WHERE
		product_popularity.popularity_sequence = 1
)
SELECT
	TO_CHAR(calendar.reporting_month, 'YYYY-MM') AS reporting_month,
	monthly_order_summary.quantity_total,
	monthly_order_summary.order_total,
	monthly_top_product.product_name,
	monthly_top_product.total_ordered
FROM
	calendar
    LEFT JOIN
	monthly_order_summary
        ON calendar.reporting_month = monthly_order_summary.order_date
    LEFT JOIN
	monthly_top_product
        ON calendar.reporting_month = monthly_top_product.order_date
ORDER BY
	calendar.reporting_month;
reporting_monthquantity_totalorder_totalproduct_nametotal_ordered
2004-031285546.6Card Holder – 2537
2004-04 – – – –
2004-05 – – – –
2004-06 – – – –
2004-07 – – – –
2004-08 – – – –
2004-09 – – – –
2004-10 – – – –
2004-11 – – – –
2004-12 – – – –
2005-01 – – – –
2005-02 – – – –
2005-03 – – – –
2005-04 – – – –
2005-05 – – – –
2005-06 – – – –
2005-07 – – – –
2005-08 – – – –
2005-09 – – – –
2005-10 – – – –
2005-11 – – – –
2005-12 – – – –
2006-012191159929KB 101/ES241
2006-021165151501.6KB 101/EN150
2006-0380367126KB 101/EN170
2006-04 – – – –
2006-05 – – – –
2006-06 – – – –
2006-0745861655.7SPNIX4.0 – UL/D44
2006-08 – – – –
2006-0913819160.6WSP DA-13035
2006-10 – – – –
2006-1112312579.2Project Management – S3.329
2006-12 – – – –
2007-01 – – – –
2007-021449120281.6KB 101/EN146
2007-032909200024.1KB 101/EN420
2007-04531636Card Organizer – 25016
2007-051026165838.2KB 101/EN129
2007-061883350019.9KB 101/ES280
2007-072030280857.1Manual – Vision Tools2.0193
2007-081644245281.3Manual – Vision Net6.3/US142
2007-091004367489.1Modem – 56/H/E104
2007-1098180709.8Mouse C/E140
2007-114687394289.2KB 101/ES500
2007-121084338672KB 101/ES200
2008-0141637299.8Screws <S.32.S>55
2008-0141637299.8Screws <B.32.P>55
2008-0267250507.9Mouse C/E90
2008-0350148552KB E/EN200
2008-04 – – – –
2008-052206205006.4Mouse C/E176
2008-061460221865.8KB 101/EN330
2008-07106080150.6Word Processing – SWP/V 4.577
2008-08162075.2Business Cards – 250/2L9

An almost “CTE-less” solution resulting in the same output can be found below. Out of necessity, I used a recursive CTE for creating the calendar with the remainder of the code relying on subqueries.

WITH calendar (reporting_month) AS (
    SELECT
    	TRUNC(MIN(oe.orders.order_date), 'MONTH')
    FROM
    	oe.orders
	UNION ALL
    SELECT
    	ADD_MONTHS(calendar.reporting_month, 1)
    FROM
    	calendar
    WHERE
    	calendar.reporting_month < (
    	SELECT
    		TRUNC(MAX(oe.orders.order_date), 'MONTH')
    	FROM
    		oe.orders
    )
)
SELECT
	calendar.reporting_month,
	monthly_order_summary.quantity_total,
	monthly_order_summary.order_total,
	monthly_top_product.product_name,
	monthly_top_product.total_ordered
FROM    calendar
	LEFT JOIN (  
	SELECT
		TRUNC(oe.orders.order_date, 'MONTH') AS order_date,
		SUM(oe.order_items.quantity) AS quantity_total,
		SUM(oe.order_items.quantity * oe.order_items.unit_price) AS order_total
	FROM
		oe.orders
		INNER JOIN
		oe.order_items
			ON oe.orders.order_id = oe.order_items.order_id
        GROUP BY
			TRUNC(oe.orders.order_date, 'MONTH')
    ) monthly_order_summary
		ON calendar.reporting_month = monthly_order_summary.order_date
    LEFT JOIN (
	SELECT
		product_popularity.order_date,
		product_popularity.product_name,
		product_popularity.total_ordered
	FROM (
		SELECT
			TRUNC(oe.orders.order_date, 'MONTH') AS order_date,
			oe.product_information.product_name,
			SUM(oe.order_items.quantity) AS total_ordered,
			DENSE_RANK() OVER (
				PARTITION BY TRUNC(oe.orders.order_date, 'MONTH')
				ORDER BY SUM(oe.order_items.quantity) DESC
			) popularity_sequence
		FROM
			oe.orders
			INNER JOIN
			oe.order_items
				ON oe.orders.order_id = oe.order_items.order_id
			INNER JOIN
			oe.product_information
				ON oe.order_items.product_id = oe.product_information.product_id
			GROUP BY
				TRUNC(oe.orders.order_date, 'MONTH'),
				oe.product_information.product_name
	) product_popularity
	WHERE
		product_popularity.popularity_sequence = 1
    ) monthly_top_product
        ON calendar.reporting_month = monthly_top_product.order_date
ORDER BY
	calendar.reporting_month;

In each solution not utilizing CTEs, you’ll notice a heavy reliance on subqueries in the solution. Arguably, this causes a loss in readability and lack of clear separation of code dedicated to solving each subproblem when compared to the solutions relying on CTEs. The point is not that subqueries are not inherently bad. In fact, many real-world problems solved using subqueries do not suffer from a loss of readability. It’s that a conscious decision to use (or not use) one over the other is required. I find when a problem requires multiple subqueries or nested subqueries, it’s often a good indicator the code should be rewritten to use CTEs or temporary tables. That said, I couldn’t possibly be covering a SQL topic without having to say that my finding is not equivalent to a hard and fast rule, but only that “it depends.”