Xml In Sql

Query XML Data in SQL
AskAI

This technical problem deals with how to query XML data in SQL in order to return it in a tabular format.

169
Jan 30
Find all nodes with a given attribute value in XML
AskAI

Given an XML document, write a SQL query to find all the nodes with a given attribute value.

106
Nov 27
Find the products with the highest price per unit.
AskAI

Given a table of products and their prices, write a SQL query to find the products with the highest price per unit.

165
Nov 26
Find all pairs of distinct values in two columns
AskAI

Write a SQL query to find all pairs of distinct values in two columns.

170
Nov 22
Find the average price of all products in a database.
AskAI

This technical problem involves writing a SQL query to find the average price of all products in a database. An example product table is provided, and the expected output is the average price of all products in the table.

150
Nov 21
Counting XML tags in a document
AskAI

This technical problem deals with counting XML tags in a document. A SQL query is provided that returns the number of XML tags of each type in a given XML document.

167
Nov 19
Get customers who have made a purchase in the last 30 days
AskAI

To get customers who have made a purchase in the last 30 days, write a SQL query that returns all customers with a purchase_date within the last 30 days.

183
Nov 18
SQL Query to Return Value of XPath Expression
AskAI

This technical problem deals with returning the value of an XPath expression from an XML document using a SQL query.

155
Nov 15