BCS 360 Study Guide - Quiz Guide: Result Set
Document Summary
Lab 4: use union operator to generate a result set consisting of vendorname and. If the vendor is in new york, the vendorstate value should be "ny", otherwise, the. Sort the final result by vendorname. select "inside ny" as [vendorstate], vendorname from vendors. Union select "outside ny" as [vendorstate], vendorstate from vendors order by vendorname: create a table which is showing people who are in both customers and investors. select customerfirst, customerlast from customers. Intersect select firstname, lastname from investors: in examples database using the paidinvoices table to find the maximum.