Using your schema from question 10 write an FLWOR XQuery expression that lists o

Question

Using your schema from question 10 write an FLWOR XQuery expression that lists only the tutors names and lists them alphabetically

10) <xs:element name="note">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="last name" type="xs:string"/>
      <xs:element name="first name" type="xs:string"/>
      <xs:element name="phone" type="xs:string"/>
      <xs:element name="e-mail address" type="xs:string"/>

<Certification details>

        <School>

                    </school>

                <College>

        </college>

</certificate>

    </xs:sequence>
  </xs:complexType>
< /xs:element>

< /xs:schema>

Explanation / Answer

let the name of the database or table be "Tutordetails" XQUERY for $Tutordetails in database1-fn:xmlcolumn('Tutordetails.First name') order by $Tutordetails/first name, return $Tutordetails/ first name

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.