I re-read my answer and the question and realized I didn't answer the question. Gsquared has it right, self joining the table to itself will give you the answer.

code isn't...

I would personally just use a group by clause on the application_id

I was having a very similar problem where I was setting the LocalPath using an expression, and it would say that it could not find the file even though the...