>
>
> Two more issues in addition to this query is:
>
> I'm using a PHP statement to find only the lastname in the name field,
> can
> this be done already in the query??
>
> A nice feature would be to only list one name if both lastnames are the
> same in one apt
a(my_compress.o): In function `my_compress_alloc':
my_compress.o(.text+0x13c): undefined reference to `compress'
I really have no idea what to do here. I don't even know how to read
libmysqlclient.a. Can anyone clue me in?
--
Philip Spradling
Unemployed C/C++/Java/SQL programme
Oh, someone should fix that... I guess it won't let you put a group statement in the
where clause.
Here is another way. On the down side, its a bit more roundabout. On the up side,
however, I actually tried it and it worked.
select col1 from t1 order by col2 desc limit 1;
-Philip
On Sun,
I could be missing something, but what about:
select col1 from t1 where col2 = max(col2);
On Sun, 12 May 2002 23:04:14 +0200
Sabine Richter <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I just want to get the value of one column in the row where max of
> another col of this table is.
> With the poss