find the max date from many table 1

[shelron]

I have a transaction table with an average of 5 rows per unique project.

I would like to find the most recent date for all projects.

The result needs to return one row for each unique project, with that row being the last entry of the set.

Help, Ron

 

[karluk]

You can simply use the max function with a group by clause

select project, max(date) from transaction_table
group by project

 

[shelron]

Thanks for the tip, the max gave me some problems, but also got me pointed in the right direction.

I ended up using a last function, then grouping, worked like a charm..

thanks, ron