MySQL Forums
Forum List  »  Connector/Node.js

Advanced Search
New Topic

SELECT DISTINCT
Posted by: dennis vavasis
Date: March 31, 2009 10:25AM

hI guys,

I am using this query to count the number of serial numbers
SELECT EXTRACTVALUE( xmlfile, 'count(//S_N)' ) FROM xml_files
which works fine.
Is there a way I can receive the unique values?
For instance the above query returns 10 but 2 of the S_N's are duplicate
thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
SELECT DISTINCT
dennis vavasis
March 31, 2009 10:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.