xsl-list
[Top] [All Lists]

SELECT DISTINCT QUERY

2003-05-23 23:44:19
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



<Prev in Thread] Current Thread [Next in Thread>