Look up the ROW_NUMBER() Function in Books Online. You can use it to distinguish the rows as you see fit then select the one you want.

If you do choose to go that way and you need help then I would advise you supply ddl/test data.