subject

Write a select statement that returns an xml document that contains all of the invoices in the invoices table that have more than one line item. this document should include one element for each of the following columns: : below is the sql part of the query that you should use so that all you have to add is the xml partselect invoicenumber, invoicedate, invoicetotal, as itemdescription, invoicelineitemamount as itemamountfrom invoices as invoice join invoicelineitems as lineitemon invoice. invoiceid = lineitem. invoiceidwhere invoice. invoiceid in (select invoiceidfrom invoicelineitemsgroup by invoiceid having count(*) > 1)order by invoicedatesave the xml document that is returned in a file named multiplelineitems. xmlgenerate an xml schema for the file and save it in a file named multiplelineitems. xsd

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 20:00
What is used to analyze and summarize your data without graphical support
Answers: 1
question
Computers and Technology, 22.06.2019 22:00
What is a distinguishing feature of today’s graphic application software?) graphic applications are used today on a variety of devices, including touch-screen kiosks and mobile phones.
Answers: 3
question
Computers and Technology, 23.06.2019 01:30
1. which of the following is a search engine? a) mozilla firefox b)internet explorer c)google d)safari 2. which of the following statements is true? a) all search engines will provide the same results when you enter the same query. b) all search engines use the same amount of advertisements. c) some search engines are also browsers. d) search engines often provide different results, even when you enter the same query.
Answers: 2
question
Computers and Technology, 23.06.2019 08:30
Helen's credit card has an apr of 15.32% and a grace period of 17 days and helen pays her balance in the full every month. if her last billing cycle ended on september 26, 2009, and she made her payment on october 11, 2009, did she owe any interest on her last statement's balance?
Answers: 3
You know the right answer?
Write a select statement that returns an xml document that contains all of the invoices in the invoi...
Questions
question
Mathematics, 08.11.2019 06:31
question
Mathematics, 08.11.2019 06:31
Questions on the website: 13722360