2011/09/27 05:32 -0700, supr_star
Here's a simple query: select name,status,min(dt), max(dt),count(*) from
mytable group by name I need an efficient way to get this data, along with the
status of the row with the max(dt). 'status' is not in the group by, so I get
apparently random sta
Here's a simple query:
select name,status,min(dt), max(dt),count(*)
from mytable
group by name
I need an efficient way to get this data, along with the status of the row with
the max(dt). Â 'status' is not in the group by, so I get apparently random
statuses. Â Is there any way to do this witho
nuary 12, 2004 2:48 AM
Subject: Re: query efficiency
> Thats not really what I meant. I have 5 (or whatever) columns in a
table.
> I need to update values changed in those columns during processing.
But I
> have no way of knowing what column values need updating. Is it worth
my
> w
Hi all,
I have two tables containing the following:
table1:
+--++
| UNID | DATE |
+--++
| 08294D5D0F9ABE6D46663300BDB6521C | 2001-09-09 02:00:30|
| FF
I have a question regarding the efficiency of an explicit JOIN statement vs.
an implicit one.
What I mean:
I have a many-to-many mapping through a mapping table. I.e. I have different
types of tools mapped to several categories in which they might belong. For
instance, a complete programming sui
