|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] SELECT DISTINCT QUERY
I want to execute a SELECT DISTINCT querry in a node tree. A have a node tree below <salesStaff> <person name="john" date="5/22/2003" time="10:00" duration="2" /> <person name="john" date="5/22/2003" time="12:00" duration="1" /> <person name="john" date="5/22/2003" time="13:00" duration="2" /> <person name="marry" date="5/22/2003" time="12:00" duration="1" /> <person name="bob" date="5/22/2003" time="9:00" duration="2" /> <person name="bob" date="5/22/2003" time="11:00" duration="2" /> <person name="john" date="5/22/2003" time="11:00" duration="2" /> <person name="john" date="5/23/2003" time="10:00" duration="1" /> <person name="jan" date="5/23/2003" time="10:00" duration="2" /> <person name="sany" date="5/23/2003" time="19:00" duration="2" /> <person name="marry" date="5/23/2003" time="15:00" duration="2" /> </salesStaff> How can I have a query like "SELECT DISTINCT name FROM salesStaff WHERE date = $today" This will return the names of the salesmen who has an appointment today. But each name must be returned only once. Thanks. Onur XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








