hi all,
I've inserted xml file :
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
zz
..
to a table:
CREATE TABLE "temp".tempxml
(
record xml
)
I can get it using:
select * from temp.tempxml
but, I can't get any values using xpath. ex:
2011/9/13 Dianna Harter :
Hi,
> [snip]
> Any suggestions to get the order by to occur first then the partition by or
> maybe there another approach that I could use?
I tried to write the query without using the window:
SELECT `X`.`consumer_id`, `X`.`move_date` , `X`.`history_timestamp` ,
