INTERVIEW QUESTIONS XML XQUERY DETAILS

Question: How to use FLWOR expression given by XQuery in XML data?

Answer: We use FLWOR expression with XQuery like that,

for $a in doc("bookmart.xml")/bookstore/book
where $a/price<150
return $a/title

We use above expression to select all title elements in bookmart element from bookstore element those has price smaller than 150.

Output:

<title lang="en">Jungle Book</title>
<title lang="en">The Book of the Thousand Nights and a Night </title>
We can also acheive this by using path expression like that,
doc("bookmart.xml")/bookstore/book[price<150]/title

Now, We can also sort this like that,
for $a in doc("books.xml")/bookstore/book
where $a/price<150
order by $a/title
return $a/title

output:
<title lang="en">Jungle Book</title>
<title lang="en">The Book of the Thousand Nights and a Night </title>
Where,
for : is used to select all book elements from bookstore into variable $a.
where : is used to select only those book elements with a price element those are less than 150.
order by : is used to inform that sorting is performed by title element.
return : used to return the title elements.

We use FLWOR expression with XQuery like that,

for $a in doc("bookmart.xml")/bookstore/book
where $a/price<150
return $a/title

We use above expression to select all title elements in bookmart element from bookstore element those has price smaller than 150.

Output:

<title lang="en">Jungle Book</title>
<title lang="en">The Book of the Thousand Nights and a Night </title>
We can also acheive this by using path expression like that,
doc("bookmart.xml")/bookstore/book[price<150]/title

Now, We can also sort this like that,
for $a in doc("books.xml")/bookstore/book
where $a/price<150
order by $a/title
return $a/title

output:
<title lang="en">Jungle Book</title>
<title lang="en">The Book of the Thousand Nights and a Night </title>
Where,
for : is used to select all book elements from bookstore into variable $a.
where : is used to select only those book elements with a price element those are less than 150.
order by : is used to inform that sorting is performed by title element.
return : used to return the title elements.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question