Diesel or petrol, when it is worth it

Hello together, we stand before our first car purchase (probably skoda roomster or renault scenic) and do not have much idea. How many kilometers is a diesel worth? Is there a skillful link? We are grateful for your help Greeting Annill