Hi,
I hope someone can help with this query, which is causing me great problems.
I have a table:
create table mytable ( id varchar(10), name varchar(10), desc varchar(10), update integer);
I want to return 1 row for each id, that contains the maximum update value for that id, and
the values for name and desc.
I've tried everything I can think of, but no luck :-(
I'm sure there is some simple trick that I'm missing.
Can someone please put me out of my misery !
Thanks
JohnT