Re: WO way to SELECT MAX(FOO) FROM BAR

2008-12-13 Thread Houdah - ML Pierre Bernard
Use SepcialityFetches from the HoudahEOAccess framework. On 11 Dec 2008, at 21:44, David Avendasora wrote: Hi all, I've googled this, but can't seem to find any answers even though I'm guessing it's a pretty common thing. I have a table that has nearly 2 million rows and I want to

WO way to SELECT MAX(FOO) FROM BAR

2008-12-11 Thread David Avendasora
Hi all, I've googled this, but can't seem to find any answers even though I'm guessing it's a pretty common thing. I have a table that has nearly 2 million rows and I want to retrieve the maximum value used in the entire table for a given field. The SQL equivelent would be: SELECT

Re: WO way to SELECT MAX(FOO) FROM BAR

2008-12-11 Thread Chuck Hill
On Dec 11, 2008, at 12:44 PM, David Avendasora wrote: Hi all, I've googled this, but can't seem to find any answers even though I'm guessing it's a pretty common thing. I have a table that has nearly 2 million rows and I want to retrieve the maximum value used in the entire table for a