TIP: Click on subject to list as thread! ANSI
echo: os2prog
to: Peter Fitzsimmons
from: Peter Garner
date: 1996-08-12 09:44:36
subject: DB2

PF> Since you can never assume anything about the
PF> sequence of an SQL result PF> set....

 PG> Why is that?  I since I am including the clause :

 PG>         order by process_date desc

PF> two with the same date,  you can not assume which will
come first;  indeed,  they two may change places on subsequent
queries

Hmmm, Must have forgotten to copy the select DISTINCT in the original
query.  This is a single column, ordered, distinct select.  The same row
cannot appear twice, etc.   Maybe I should repost this again.  I must
have been VERY unclear both times, sorry.

Thanks,

Peter

--- WILDMAIL!/WC v4.12 
* Origin: GREATER CHICAGO Online!! 708-895-4042 (1:2222/895.0)
SEEN-BY: 50/99 270/101 620/243 625/100 711/401 409 410 413 430 808 809 934
SEEN-BY: 711/955 712/407 515 624 628 713/888 800/1
@PATH: 2222/895 109/347 18 13/25 396/1 270/101 712/515 711/808 934

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.