From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | operationsengineer1(at)yahoo(dot)com, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: How To Exclude True Values |
Date: | 2006-06-08 01:03:21 |
Message-ID: | 20060608010321.70607.qmail@web31812.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> i think i've figured out the gist of the thought
> process behind the SQL query...
>
> 1. select everything from t_inspect_result as table a
> 2. select max timestamp value entries in
> t_inspect_result as table b
> 3. choose only choose those rows where the max
> timestamps of table a and b are equal.
>
> is that about it?
The one problem with query would be if there is a possibility that two differnt tests will have
the exact same time stamp.
If that is a possibility, then you could use the exact same query structure but replace
Max(timestamp) with max(inspect_result_id) and then join on inspect_result_id instead.
Regards,
Richard Broersma
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-06-08 04:32:36 | Re: Query to return modified results at runtime? |
Previous Message | George Handin | 2006-06-08 00:29:23 | Query to return modified results at runtime? |