Subject: SELECT DISTINCT QUERY
From: "Onur Esnaf" <oesnaf@xxxxxxxxxxxxxxx>
Date: Sat, 24 May 2003 09:44:19 +0300
|
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
|