| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| 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™.