sql statement

[LaxRoth]

Hi, i've got a question using SQL. I have a table which has following attributes: beginn, end, ressource. all are numbers.
i need a statement to select all records on one ressource that have the latest end of all records on the same ressource. anyone a suggestion? do i need a join or something?





thx in forward,

LaxRoth

:confused:

[Gabriel Fleseriu]

select ressource, max(end) from your_table
group_by ressource;


Is this what you want?:confused: